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 , , , , | 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

Posted in SQL Server Performance | Tagged , | Leave a comment

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

Posted in SQL Server Performance | Tagged , | Leave a comment