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 »Mar 042016
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 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 »Oct 122015
SQL Server MVP Matan Yungman shows ways to identify specific query bottlenecks while the query is running, mostly using native tools in SQL Server.
Continue Reading »Sep 112015
Paul White (@SQL_Kiwi) discusses some things to know about INSTEAD OF triggers – from execution plans and worktables to a cardinality estimation bug in SQL 2014.
Continue Reading »