SQL Server 2012 Service Pack 2 Cumulative Update #8

SQL Server / SQL Server 2012

SQL Server 2012 Service Pack 2 Cumulative Update #8

Aaron Bertrand September 22nd, 2015 SQL Server / SQL Server 2012 2

Microsoft has released Cumulative Update #8 for SQL Server 2012 Service Pack 2.

KB Article: KB #3082561
24 fixes total (23 fixes listed publicly at time of publication)
Build number is 11.0.5634
Relevant for @@VERSION 11.0.5058 through 11.0.5633

Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, write at SQLPerformance and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a father of two, a huge hockey and football fan, and my pronouns are he/him. If I've helped you out, consider thanking me with a coffee. :-)

AaronBertrand says:

October 8, 2015 at 5:54 PM

Chris, essentially, the only change will be that the up-front memory grant will be larger when the trace flag is enabled. They've updated the wording in the KB slightly, and I've asked them to add more detail, but so far nothing…
Chris Wood says:

September 22, 2015 at 7:44 PM

So does anybody understand how KB3088480 for data spills in large sorts will work? What is trace flag 7470 going to do?
Chris