As a consultant whose job description includes putting out performance fires, I get to see a lot of problematic queries that can dramatically harm overall server performance and throughput. Wondering ...

Ok, let's say I have three different queries that all return the same result set. One uses a temp table, the other a correlated subquery, and the third is just a HUGE set of union queries, etc... all ...

There are plenty of ways to get the most out of SQL Server without just upgrading to the latest version. For database admins working with older (maybe much older) SQL Server systems, here are four ...