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: HD Insight
Post
My links of the week – November 17, 2013
Here are the links for the last week. It is a rather extensive list, resulting from the difficulties in choosing from so many interesting articles. SQL Server: Paul Randal’s Are I/O latencies killing your performance? addresses latency in tempdb and log files access, starting with the results of a survey that collected such data from around...