Here is my choice links for the past week. SQL Server: Kendra Little’s UPDATE STATISTICS: the Secret IO Explosion shows how updating statistics can cause a bit of IO and suggests ways to accomplish it in a lighter fashion. Gregory Larsen’s Stairway to Advanced T-SQL Level 2: Writing Subqueries is a rather comprehensive presentation of subqueries in T-SQL. Aaron...
Tag: SQL Server
Post
My links of the week – January 26, 2014
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...