You've tried everything you know to tune that query, but it's just not going any faster. There are some performance problems holding you back, and you're not sure how to fix them. In this Advanced Index Tuning class, you’ll learn about filtered indexes, computed columns, and indexed views. I want to teach you how they work, what kind of problems they can solve, and their shortcomings. 95 Minutes, Streaming

Everything is on the table here. These are the things a DBA must know to fix the problems everyone else thinks are too hard to solve. You'll learn innovative techniques to solve problems no matter what your situation is. This video will cover parameter sniffing, lookups, sorts, functions, optional parameters, paging, and how to tune those gigantic queries that bring your server crashing down. 4.5 Hours, Streamed

This is Part 2 of videos dedicated to SQL Advanced Performance Tuning Training. We teach you everything a DBA needs to know about parameter sniffing, lookups, sorts, functions, optional parameters, paging, and tuning queries. You’ll become the person to call when a solution seems impossible. 4.5 Hours, Streamed

Worried about blocking in SQL Server? It takes a lock to cause a block! In this video course, you'll learn all the best query and index tuning techniques to avoid the locking and blocking that blow up your alerts and prevent your users from accomplishing anything. 70 Minutes, Streamed

There are some optimizer improvements in SQL Server 2019 that deserve a closer look. Things like Batch Mode for Row Store, Scalar Function Inlining, and Table Variable Deferred Compilation. Check out this course to learn what they help, what they hurt, and most importantly: how they change your job as a query tuner. 100 Minutes, Streamed

In this course, you'll learn about wait stats like CXPACKET, CXCONSUMER, SOS_SCHEDULER_YIELD, THREADPOOL, and how to use them to figure out if your server is truly bottle-necked, or if you've made some bad decisions. Blindly trying to upgrade based on SQL Server hardware recommendations can make things more expensive than they need to be. 70 Minutes, Streamed

You know all those PAGEIOLATCH waits you're seeing? That's your SQL Server reading data from disk because you didn't love it enough. In this course, you'll learn why your SAN really isn't as fast as the brochure from your vendor says it is. You'll also learn what those "15 second I/O warnings" in your error log really mean, and the One Weird Trick™ a DBA needs to fix it. 30 Minutes, Streamed

RAM, Memory, that thing your VM Admin won't give you any more of. No matter what you call it, it's one of the most crucial design choices when a DBA is building or reviewing SQL Server hardware. This isn't another hour of staring at outdated metrics like PLE, this is a modern look at how your database uses memory, and your actual SQL Memory Requirements. 70 Minutes, Streamed

IO_COMPLETION, SLEEP_TASK, EXECSYNC, RESOURCE_SEMAPHORE_QUERY_COMPILE, MEMORY ALLOCATION, CMEMTHREAD, ASYNC_NETWORK_IO…? Let’s dive into some of the weirder waits you might see coming from SQL Server, how they can be part of performance problems, and how to solve them. If you have questions about any of these wacky waits or SQL Server hardware limits, look no further. 20 Minutes, Streamed

In this course, I want to teach you about common performance problems you can solve by index tuning SQL Server, and how you can use your query plan and a little brain meat to figure out exactly what you need to do. Most people only worry about an index when it’s fragmented, or when they see a scan instead of a seek. And boy howdy, are they wrong about that! 100 Minutes, Streamed

You've got slow queries, and you're not sure where to start hunting down problems. Start here to learn about the more common, easy to fix issues you'll see. In this query tuning guide, you'll learn how to improve SQL Server performance. We’ll cover issues like implicit conversion, SARGability, parallelism, lookups, and more! You'll also get a gentle introduction to how the optimizer works. 120 Minutes, Streamed

You know those things people keep telling you to rebuild? Yeah, stop doing that. Your server has enough problems. This SQL tutorial will teach you the upsides, downsides, and insides of indexes. When you're done, you'll have the SQL knowledge to understand why you need indexes, and how to design them for success. 75 Minutes, Streamed

The best laid plans of mice and optimizers can sometimes go awry. I’ll teach you basic SQL queries, which parts of query plans to pay attention to, where the optimizer hides its dirty little secrets, and how they sometimes lie to a DBA like you. 45 Minutes, Streamed

Have you always wondered what happens when you run a query? How the optimizer chooses indexes, and comes up with a query plan? This video is a critical SQL crash course on query execution. It’s just what you need to learn SQL fast and become a better DBA. 50 Minutes, Streamed

Want to stop staring at waits and start analyzing them effectively? The best way to learn SQL includes learning why waits matter, which wait stats you should pay attention to, when you should do something about them, and what you can do to really make a difference that end users will notice. Why wait? Start this online SQL class today! 55 Minutes, Streamed