SQL Plan Archives - Page 10 of 12

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

Don't just blindly create those "missing" indexes!

SentryOne's Aaron Bertrand (@AaronBertrand) discusses a few additional places to get information useful for decisions about creating new indexes that are suggested as "missing" by various tools.

Aaron Bertrand ◆ June 6, 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

Impact of the query_post_execution_showplan Extended Event in SQL Server 2012

Jonathan Kehayias (@SQLPoolBoy) of SQLskills.com evaluates the performance impact of query_post_execution_showplan and explains why you need to be very careful about using it in a production environment.

Jonathan Kehayias ◆ March 25, 2013

4

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

Obfuscate sensitive data in your execution plans

Getting help with execution plans outside of your company can be a challenge, since you may not be willing to share information such as server names, database names, object names, schema, column names, index structure, and so on. Read on to see how you can protect your execution plans with a free PowerShell script from Jonathan Kehayias of SQLskills.

Aaron Bertrand ◆ March 1, 2013

2