T-SQL Tuesday #56 : Assumptions

This month's T-SQL Tuesday is about assumptions in SQL Server. Over on our new consolidated team blog at SQL Sentry, I discuss the following assumptions I come across with relative frequency:

  1. Case will always short circuit
  2. A seek is better than a scan, always
  3. A query without ORDER BY will always order by _________
  4. SQL Server's defaults are great
  5. If Microsoft does it, it must be a good idea!

Continue reading…

Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, speak frequently at conferences, and write at SQLPerformance and MSSQLTips. I recently joined the team at Wayfair and hope to blog about some of the scale challenges I've already started helping to solve.

1 Response

  1. pmbAustin says:

    Thanks for sharing this!  This was a great read… and good to see a lot of my own 'best practices' validated 🙂