Tag Archives: Performance Tuning

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

Getting back on the horse…

It’s been three weeks since I spent much time thinking about this site, mostly due to the distractions of starting a new gig and learning a whole new system. I know I’m not the first to think or say… type… … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment