sql2016

Changes to auto update stats thresholds in SQL Server 2016

Last Updated February 25, 2016

TL;DR As of CTP 3.3, it’s the same behavior as Trace Flag 2371, in 2008 R2 SP1 and onward. That basically means that the bigger your table is, the fewer rows need to be modified before an automatic statistics update occurs. Slightly longer… The change was announced over here. At first I thought, woah, cool,…

#MSIgnite SQL Server Unplugged Q&A Summary

Last Updated May 7, 2015

Brent Ozar

SQL Server

This afternoon, we had one of my favorite sessions: the off-the-cuff Q&A with some of Microsoft’s best and brightest. I probably missed somebody, but for sure we had Conor Cunningham, Joe Yong, Jos de Bruijn, Kevin Farlee, Luis Carlos Varga Herring, Mike Weiner, Sunil Agarwal, and Tiffany Wissner. Hubba hubba. SQL Server Unplugged These sessions are fun to…