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?