Esoteric

Resource governor is a useful feature in SQL Server 2008 which can provide instance-level throttling of CPU and memory resources. I will not dwell into the basic details and architecture, as they are very well documented in Books Online and also in the Read More...

This is really not a T-SQL anti-pattern as much as it is a database design issue, but we see it so often that it’s worthwhile bringing it up and clarifying things. For illustrating the scenario, let’s examine the table Person.Contact in the AdventureWorks Read More...