SQL Server Management Studio has a very complex interface. Learn tricks to make using SSMS more fun and efficient.
The examples in this course were recorded using SQL Server Management Studio (free download from Microsoft) using the “default” keyboard mapping scheme (Tools -> Options -> Keyboard).
Sometimes performance can go badly wrong if SQL Server has an imperfect index for an query.
In this session, I show you a query whose performance regresses after you add a nonclustered index. Your challenge is to figure out why the query got slower.
Try your hand at speeding up the query by tuning the TSQL. Afterward, I explore the query execution plan with you and walk you through multiple potential solutions, showing the pros and cons of each one.
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
Demos are run against SQL Server 2016, but most of the hints and settings shown can be used against lower or higher versions of SQL Server, too!
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.
Table partitioning is a fantastic tool to help you manage tables with skyrocketing rowcounts. SQL Server 2016 SP1 made table partitioning available in Standard Edition, so you may be planning to add partitioning to your database. This course teaches you to use execution plans to troubleshoot regressed queries using partitioned tables. You will learn what “non-aligned” indexes are, how to tell how many partitions a query is really using, and see a variety of methods to speed up your queries.
Your SQL Server is slow, and you suspect blocking. Try the course quizzes anytime: blocking diagnosis, troubleshooting retroactively, deadlocks
You need to prove if blocking really is the culprit and set up simple, lightweight monitoring using free tools and scripts to find the queries causing your blocking problems.
Copyright (c) 2025, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.