July 8, 2014 | SQL Server

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…

1 comment on this post

    • pmbAustin - July 10, 2014, 6:04 PM

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

Comments are closed.