Here are the links for the past week. SQL Server: Jes Schultz Borland’s Improving the Performance of Backups suggests a few ways to improve the performance of backup operations. The comments also suggest further reading with additional great advice. Hugo Kornelis’s Parameterization and filtered indexes (part 1) and Parameterization and filtered indexes (part 2) address the issue...
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...