Tip : Why the SQL Server FORCESCAN hint exists
This month's T-SQL Tuesday is about assumptions in SQL Server.