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