March 2013 - SQLPerformance.com

Making the Case for Regular SQL Server Servicing

Glenn Berry (@GlennAlanBerry) of SQLskills.com gives some pretty strong arguments for keeping your SQL Server instances current on both Service Packs and Cumulative Updates.

Glenn Berry ◆ March 28, 2013

7

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

Performance-related fixes for SQL Server 2012

In an effort to encourage you to keep your SQL Server 2012 instances up to date, I wanted to highlight a slew of performance-related fixes that are mostly available only through Service Pack 1 or various Cumulative Update packages.

Aaron Bertrand ◆ March 19, 2013

1

Break large delete operations into chunks

Aaron Bertrand (@AaronBertrand) discusses ways to optimize large delete operations, both to make them faster, and to minimize impact on the transaction log.

Aaron Bertrand ◆ March 13, 2013

48

Anonymize your plan details natively in Plan Explorer

I wanted to talk about two new features in SQL Sentry Plan Explorer: Plan obfuscation, where you can hide sensitive information in your plans before sharing them, and custom layouts, a way to take complete control over the visual representation of your graphical plans.

Aaron Bertrand ◆ March 11, 2013

6

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