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.
Continue Reading »Mar 282013
Mar 252013
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.
Mar 202013
Paul White dissects a few execution plans and explains why SQL Server can sometimes have problems optimizing views that incorporate window functions.
Continue Reading »Mar 192013
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.
Continue Reading »Mar 132013
Aaron Bertrand (@AaronBertrand) discusses ways to optimize large delete operations, both to make them faster, and to minimize impact on the transaction log.
Continue Reading »Mar 112013
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.
Continue Reading »Mar 012013
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.
Continue Reading »