Aaron Bertrand (@AaronBertrand) kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.Continue Reading »
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 »
SQL Sentry has released a new Q & A site, answers.SQLPerformance.com/, that integrates with SQL Sentry Plan Explorer. This integration allows users to upload execution plans from directly within the application, and get feedback and suggestions from noted execution plan experts, including Paul White. Read on to learn more…Continue Reading »
My co-worker Steve Wright (blog | @SQL_Steve) prodded me with a question recently on a strange result he was seeing. In order to test some functionality in our latest tool, SQL Sentry Plan Explorer PRO, he had manufactured a wide and large table, and was running a variety of queries against it. In one case he was returning a lot of data, but
STATISTICS IO was showing that very few reads were taking place.