SQL Optimizer Archives - SQLPerformance.com

Can ColumnStore Help Pagination Workloads?

Posted by Aaron Bertrand on January 15, 2016 1 Response »

Jan 152016

Aaron Bertrand (@AaronBertrand) revisits an older post about SQL Server pagination to see if any implementation of ColumnStore indexes can improve performance.

Another Reason to Use NOEXPAND hints in Enterprise Edition

Posted by Paul White on December 30, 2015 3 Responses »

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.

Optimizing Update Queries

Posted by Paul White on December 16, 2015 3 Responses »

Dec 162015

Paul White (@SQL_Kiwi) spends some time optimizing update queries in order to explore some SQL Server internals.

More showplan improvements? Yes, please!

Posted by Aaron Bertrand on December 8, 2015 No Responses »

Dec 082015

Aaron Bertrand (@AaronBertrand) highlights a handful of Connect items aimed at improving SQL Server showplan diagnostics and query tuning in general.

Hash Joins on Nullable Columns

Posted by Paul White on November 3, 2015 11 Responses »

Nov 032015

Paul White (@SQL_Kiwi) discusses some less well-known query optimizer features and limitations, and explains poor performance of certain hash joins.

Interesting things about INSTEAD OF triggers

Posted by Paul White on September 11, 2015 7 Responses »

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.

Improving the Top / Top Descending Median Solution

Posted by Paul White on August 6, 2015 2 Responses »

Aug 062015

Back in January 2015, my good friend and fellow SQL Server MVP Rob Farley wrote about a novel solution to the problem of finding the median in SQL Server versions prior to 2012. As well as being an interesting read by itself, it turns out to be a great example to use to demonstrate some

1 2 3 … 5 6