New Course: SQL Server: Troubleshooting Query Plan Quality IssuesBy Jason Salmond
Joe Sack of SQLskills has just published a new course: SQL Server: Troubleshooting Query Plan Quality Issues
There are many problems that can lower the performance of your workload and one of the most common is an incorrect query plan. Often the poor query plan is chosen because the cardinality estimate is wrong – the estimate by the query processor of how many table rows will be involved in the query. Joe does a great job at showing you how to recognize when the query processor has an incorrect estimate, along with explaining and showing a multitude of possible causes, plus how to fix them.
This course is perfect for developers, DBAs, and anyone responsible for performance tuning on SQL Server. The information in the course applies to all version from SQL Server 2005 onwards.
Click here and enjoy the course now