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...
Tag: Azure SQL VM
Post
My links of the week – 29 December, 2013
Here are the links for this week. SQL Server: Kendra Little’s Can High MaxDOP make a query SLOWER? explores the relation between the MAXDOP value and query performance. Having a high value doesn’t necessarily mean better performance. In fact, it can mean worse performance. Daniel Farina’s Understanding SQL Server Memory-Optimized Tables Hash Indexes provides a detailed explanation of...