Great Articles at SQLPerformance.com
There are so many good articles from SQLPerformance.com this ICYMI article that it’s hard to know which are best to highlight in the limited space.
So, I’ll be arbitrary and simply choose a few of my favorite entries as well look back:
Paul Randal (b |t) at SQLSkills.com refutes the age-old myth that TRUNCATE TABLE and DROP are not logged operations. I love the full T-SQL reproduction of the issue so that you can see the internals in action.
Query Tuning Insight at Answers.SQLPerformance.com
More great query tuning tips and techniques are coming in at http://answers.SQLPerformance.com every week. Get involved! Start uploading your own difficult SQL statements, read the clever solutions to other query tuning challenges, and provide your own feedback. I always learn from Paul White (b|t), when I read his solutions to tough query turning problems. Here are a couple of my favorites:
Microsoft MVP Michael Swart (b | t) and Paul White discuss a query which delivers a bad plan and, in the process, go into a deep dive about how and at what stages the SQL Server query engine might simplify a query execution plan by removing unnecessary joins.
Paul White dives into an interesting situation where a normal-seeming query causes intermediate work sets to spool to physical disk, thereby causing the query to run much too long.
Once again, Paul White teaches me new things. This time he shows how to better understand and fix JOIN cardinality estimates.
Let me know what you think! Thanks,