In an effort to encourage you to keep your SQL Server 2012 instances up to date, I wanted to highlight a slew of performance-related fixes that are mostly available only through Service Pack 1 or various Cumulative Update packages.
SQL Server 2012 Service Pack 1 Cumulative Update #3 Build # 11.0.3349 KB Article: KB #2812412 38 fixes! Relevant for builds 11.0.3000 -> 11.0.3348 NOT for SQL Server 2012 RTM (11.0.2100 -> 11.0.2999) SQL...
I discuss ways to optimize large delete operations, both to make them faster, and to minimize impact on the transaction log.
See how you can protect your execution plans with a free PowerShell script from Jonathan Kehayias of SQLskills.
