SQL Optimizer Archives - Page 7 of 7

Follow-up on Summer Performance Palooza 2013

Aaron Bertrand (@AaronBertrand) reflects on the presentation he gave during the PASS Performance VC Summer Performance Palooza 2013 on June 27th, including a wealth of responses to Q & A.

Aaron Bertrand ◆ July 26, 2013

5

Two Partitioning Peculiarities

Paul White (@SQL_Kiwi) talks about two scenarios where the order of columns in your query can affect query optimization.

Paul White ◆ July 24, 2013

9

Aggregates and Partitioning

Paul White (@SQL_kiwi) talks about a regression in the optimizer's handling of aggregates against partitioned tables when moving from SQL Server 2005 to SQL Server 2008+.

Paul White ◆ July 18, 2013

0

Working Around Missed Optimizations

Paul White (@SQL_Kiwi) continues his discussion about optimization and how recognizing transformations can help you make better decisions about potential query re-writes.

Paul White ◆ July 8, 2013

3

Optimization Phases and Missed Opportunities

Paul White (@SQL_Kiwi) talks about optimization stages and explains how to get more insight into missed opportunities.

Paul White ◆ June 26, 2013

15

Another argument for stored procedures

Aaron Bertrand (@AaronBertrand) talks about a subtle way that ad hoc queries can interfere with SQL Server performance by taking up more space in the plan cache than they really need.

Aaron Bertrand ◆ May 17, 2013

15

How filtered indexes could be a more powerful feature

Aaron Bertrand (@AaronBertrand) of SQL Sentry discusses a couple of advantages and a hefty list of limitations with filtered indexes in SQL Server 2008 and above, with links to no less than 36 Connect items!

Aaron Bertrand ◆ April 24, 2013

4

The Case of the Cardinality Estimate Red Herring

SQLskills' Joe Sack (@josephsack) walks us through an interesting scenario where we might blame a query performance issue on parameter sniffing or bad statistics, when it actually turns out that a check constraint is the best solution to keep the optimizer honest.

Joe Sack ◆ April 19, 2013

5

Optimizer Limitations with Filtered Indexes

Paul White (@SQL_Kiwi) makes some great points about limitations in SQL Server's optimizer, and things you need to watch out for, when it comes to filtered indexes.

Paul White ◆ April 4, 2013

18

The Problem with Window Functions and Views

Paul White dissects a few execution plans and explains why SQL Server can sometimes have problems optimizing views that incorporate window functions.

Paul White ◆ March 20, 2013

9

The Halloween Problem – Part 4

The Halloween Problem has a number of important consequences for SQL Server execution plans. In this final part of the series, we look at some of the tricks the optimizer uses to avoid adding an Eager Table Spool to every update query that might encounter the Halloween Problem.

Paul White ◆ February 20, 2013

15