Erin Stellato (@erinstellato) of SQLskills.com tells us about statistics, sample size and the impact different choices can have on duration and subsequent queries.
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.
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…
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.
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.
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.
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.
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.
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.
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.
