TSQL Tue #59: My Heroes
I’m looking forward to reading the TSQL2SDAY posts this month. Hero worship is something I have a bit of a problem with. The problem being, there are way too many … Continue reading
October 14, 2014 · Leave a comment
Violating AdventureWorks Dating Policy with Merge, Hash, and Loop Joins
The logical joins (inner, outer, left, right etc) are familiar to any SQL pro. As the optimizer selects the physical join type that will actually perform the work however, this part of … Continue reading
October 13, 2014 · Leave a comment
Rolling Upgrade: Synch Mirrors, Log Shipped DR – Lessons Learned
We recently did a hardware/software upgrade of a set of servers participating in synchronous mirroring for HA purposes with a log shipping solution for disaster recovery to a remote location. … Continue reading
October 2, 2014 · Leave a comment
Russ Thomas - SQL Judo 