I treat a common scenario: behavior differs between two SQL Server databases that may be the same version, but different compatibility levels.

Tip : What Effect Does Persisting a Computed Column Have in SQL Server?

I discuss the NOLOCK hint in SQL Server, and why you want to avoid slapping it onto every table mentioned in every query.

Tip : What Happens When a Computed Column is Persisted in SQL Server?

I discuss examples where people expect SQL Server to perform tasks that really should be performed outside the scope of the database.

Tip : Change All Computed Columns to Persisted in SQL Server

I discuss ten common cases of misplaced optimization.

Tip : SQL Server Video – Tricks to play on your DBA – 2

I explain why you should avoid helper functions, and join against the catalog views instead.