Category Archives: SQL Server Performance
Hashbytes – VARCHAR vs. VARBINARY Performance
A recent post on sqlservercentral.com got me thinking about Hashbytes recently. I was ignoring the issue of getting a false positive using a hashbyte solution to check for errors, and focused on the performance of the routine. My initial pass … Continue reading
Posted in SQL Server Performance
Tagged hashbytes, Performance Tuning, sql server 2005, T-SQL, varbinary
Leave a comment
Indexes, Dynamic Views, and you.
I was trying to re-invent the wheel this week by writing an index creation script / procedure using the dynamic views provided by Microsoft in my 2k5 database. After looking in BoL and other sources for what the columns really … Continue reading
Shrink Database and “free” code
I had a problem at work today resulting from running some “free” code. When I finally found the culprit I knew that I had a topic to write about, and upon arrival home I came here to write a note … Continue reading