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: SQL Server
Post
T-SQL Tuesday #50 – Automation – When repetition is really what you want
This post is meant to be part of January 2014 edition of T-SQL Tuesday, a rotating blog party started by Adam Machanic (@AdamMachanic | blog). This month’s edition is hosted by Hemanth.D (@SQLChow | blog) and the topic is automation: “Automation plays a huge part in our lives and the DBA profession is not so different. A couple of years ago...