Tim Radney (@tradney) of SQLskills talks about the initial differences he has encountered while mastering the art of performance tuning Azure SQL Database.
Continue Reading »Mar 292016
Mar 222016
Paul White (@SQL_Kiwi) shows how an update may fail when a partition has some data on a read-only filegroup, and explains several workarounds.
Continue Reading »Mar 182016
SQL Server 2016 RC0 introduces a new native string splitting function, STRING_SPLIT. Aaron Bertrand (@AaronBertrand) compares its performance to existing methods.
Mar 112016
SQL Server 2016 allows you to enable instant file initialization during installation; Aaron Bertrand (@AaronBertrand) looks at how this can impact tempdb data file creation.
Continue Reading »Mar 042016
Aaron Bertrand (@AaronBertrand) shares some insight about early changes to Plan Explorer that help to provide you with the most accurate information we can.
Continue Reading »