
Tuning a Stored Procedure - SQLChallenge (1 hour 10 minutes)
Your challenge is to identify which statement is slowing down our stored procedure the most, then tune the code to speed it up.
Your challenge is to identify which statement is slowing down our stored procedure the most, then tune the code to speed it up.
You’ve got a query that is just too slow!
A database administrator has changed Cost Threshold for Parallelism on the instance, and you’ve got a query that’s slowed down.
Learn why SQL Server’s table partitioning feature won’t make your queries against disk-based rowstore indexes faster– and may even make them slower.
Want a built-in assistant performance tuner in SQL Server?
Why would using a temp table cause a stored procedure to slow down dramatically and use massively more logical reads, compared to a permanent table?
Get the best performance for your windowing functions.
Sometimes performance can go badly wrong if SQL Server has an imperfect index for an query.
In this course you’ll learn the pros and cons of using hints, trace flags, and scoped database configuration to tune your queries in SQL Server.
Try the course quizzes anytime: using hints, recompile, optimizer hotfixes
Some queries may get slower after you partition your tables: the SQL Server optimizer doesn’t always use indexes the same way after those indexes are partitioned into chunks.