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
About the Author
- Video: Plan Your Execution with SQL Query Tuning
- New Course: SQL Server Performance: Introduction to Query Tuning
- New Course: SQL Server: Common Performance Issue Patterns
- New Course: SQL Server- Performance Troubleshooting Using Wait Statistics
- New Course: SQL Server: Benchmarking and Baselining
- Meet the Author: Pinal Dave and Vinod Kumar on SQL Server Performance: Introduction to Query Tuning
- New Course: Understanding Server Hardware
- New Course: SQL Server: Transact-SQL Basic Data Retrieval
- New Course: SQL Server: Transact-SQL Basic Data Modification
- Troubleshooting Common Cisco OSPF Issues