Here is my choice of links for the past week. SQL Server: Paul Randal’s Avoiding Knee-Jerk Performance Troubleshooting warns against superficial analysis of performance problems and offers examples of situations where that can happen, related to wait statistics. Kendra Little’s Statistics Matter on Temp Tables, Too shows that statistics are relevant in temp tables too and suggests...
Tag: ASP.NET
Post
My links of the week – January 19, 2014
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...