SQL Performance Archives - Page 27 of 31

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

Microsoft Announces SQL Server 2012 R2 and SQL Server 2012 R3!

Microsoft announced today that their next two major releases, each of which contains a major performance-related feature, will follow a naming strategy similar to the 2008 -> 2008 R2 story. Read on for more…

Aaron Bertrand ◆ April 1, 2013

8

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

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

A Look At DBCC CHECKCONSTRAINTS and I/O

Erin Stellato of SQLskills takes a deep look into the I/O impact of running DBCC CHECKCONSTRAINTS, including explaining why some check methods may consume a lot more I/O than others.

Erin Stellato ◆ February 28, 2013

8

2013 MVP Summit : A quick review and a peek forward

I had a great time at the MVP Summit last week. Caught up with a lot of friends, tried some new foods (including Tempura Fried Kurobuta Bacon), and took in some great technical sessions.

Aaron Bertrand ◆ February 25, 2013

0

Transaction Log Configuration Issues

Paul Randal of SQLskills continues his series on maintaining happy and healthy transaction logs in SQL Server, this time focusing on configuration issues that can lead to less than optimal performance.

Paul Randal ◆ February 22, 2013

8

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