Aaron Bertrand (@AaronBertrand) continues his series on widening an IDENTITY column, showing how he would attack the problem directly.
Continue Reading »Aug 042016
Jul 282016
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.
Continue Reading »Jul 212016
Erin Stellato shows the combined effect of different versions of the cardinality estimator and trace flag 2389 on an ascending key model.
Continue Reading »Jul 112016
Aaron Bertrand (@AaronBertrand) follows up on a recent post about DATEFROMPARTS() with a deeper look into the estimates and potential mitigation techniques.
Continue Reading »Jul 012016
Aaron Bertrand (@AaronBertrand) asks you to vote for and, more importantly, comment on a Connect item aimed at adding MAXDOP controls to statistics updates.
Continue Reading »Jun 232016
Tim Radney (@tradney) of SQLskills shows us how the Stretch Database feature has evolved from its early CTP beginnings to the RTM version released earlier this month.
Continue Reading »Jun 142016
For this month's T-SQL Tuesday, Rob Farley takes a look at a couple of unexpected aspects of query plans you might observe when using Temporal Tables in SQL Server 2016.
Continue Reading »