Aaron Bertrand (@AaronBertrand) explores yet another scenario where a date/time function seems to cause the optimizer to behave unexpectedly.
Continue Reading »Apr 112016
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 »Jan 152016
Aaron Bertrand (@AaronBertrand) revisits an older post about SQL Server pagination to see if any implementation of ColumnStore indexes can improve performance.
Continue Reading »Dec 302015
Paul White (@SQL_Kiwi) goes into detail about another reason you'll want to use the NOEXPAND hint, even when using Enterprise Edition.
Continue Reading »Dec 162015
Paul White (@SQL_Kiwi) spends some time optimizing update queries in order to explore some SQL Server internals.
Continue Reading »Dec 082015
Aaron Bertrand (@AaronBertrand) highlights a handful of Connect items aimed at improving SQL Server showplan diagnostics and query tuning in general.
Continue Reading »Nov 032015
Paul White (@SQL_Kiwi) discusses some less well-known query optimizer features and limitations, and explains poor performance of certain hash joins.
Continue Reading »