July 2016 - SQLPerformance.com

AT TIME ZONE – a new favourite feature in SQL Server 2016

Rob Farley explains why AT TIME ZONE is his new favourite feature in SQL Server 2016, but also shows that it can make a mess of cardinality estimates.

Rob Farley ◆ July 28, 2016

34

Trace Flag 2389 and the new Cardinality Estimator

Erin Stellato shows the combined effect of different versions of the cardinality estimator and trace flag 2389 on an ascending key model.

Erin Stellato ◆ July 21, 2016

6

Paying Attention to Estimates

Aaron Bertrand (@AaronBertrand) follows up on a recent post about DATEFROMPARTS() with a deeper look into the estimates and potential mitigation techniques.

Aaron Bertrand ◆ July 11, 2016

0

A potential improvement for statistics updates : MAXDOP

Aaron Bertrand (@AaronBertrand) asks you to vote for and, more importantly, comment on a Connect item aimed at adding MAXDOP controls to statistics updates.

Aaron Bertrand ◆ July 1, 2016

3