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...
Tag: parameter sniffing
Post
My links of the week – December 15, 2013
Here is my selection of the links from the past week. SQL Server: Last week was T-SQL Tuesday week, Waits being this month’s subject. Robert L. Davis was the host, and several interesting posts are included in his roundup: T-SQL Tuesday #49: Wait For It Roundup. Basit Farooq’s Understanding SQL Server Query Optimization – Part...