Here are my choice of links for the past week. SQL Server: Gail Shaw’s SQL Server Deadlocks by Example provides a good overview of deadlocks in SQL Server, with advice on how to detect and avoid them. Thomas Kejser’s Clustered Indexes vs. Heaps analyses common table usage scenarios to determine whether using clustered indexes is a good...
Post
My links of the week – January 12, 2014
Here are my choice of links for the past week. SQL Server: Brent Ozar’s What’s the Smallest SQL Server You Should Build? provides some advice on the hardware configuration for a “small” SQL Server that gets the best value from the licensing costs of SQL Server 2012, considering both the Standard and Enterprise Editions and...