Tim Radney talks about some of the typical SQL Server mishaps he comes across out in the wild, and resources you can use to avoid them in your own environments.
Erin Stellato lists out all of the enhancements to statistics in SQL Server over the years, from SQL Server 7.0 all the way through to SQL Server 2017.
Aaron Bertrand (@AaronBertrand) follows up on a recent post about DATEFROMPARTS() with a deeper look into the estimates and potential mitigation techniques.
Aaron Bertrand (@AaronBertrand) asks you to vote for and, more importantly, comment on a Connect item aimed at adding MAXDOP controls to statistics updates.
Jonathan Kehayias (@SQLPoolBoy) takes a closer look at a new trace flag that allows you to process multiple concurrent statistics updates on the same table.
Dan Holmes (sql.dnhlms.com) talks about a solution he developed to manually coerce statistics to be more accurate and produce better, more predictable execution plans.
Erin Stellato (@erinstellato) of SQLskills demonstrates that, while incremental statistics can help with maintenance, they are ignored by the optimizer.
