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:
- Case will always short circuit
- A seek is better than a scan, always
- A query without ORDER BY will always order by _________
- SQL Server's defaults are great
- If Microsoft does it, it must be a good idea!