Make Your SQL Server Queries Faster Than Your Neighbour’s
Everyone wants fast queries. Your neighbour probably claims theirs are faster. This one hour session helps you change that story. You will learn simple and practical tuning techniques that make your SQL Server queries run quicker and smoother than ever.
We begin with waits. You will learn how to read basic wait stats to see where SQL Server is slowing down. This helps you stop guessing and start fixing the real issue. You will understand why some queries sit around waiting while others fly.
Next, we step into indexes. You will see how the right index can give your query a clear advantage. We look at missing indexes, bad indexes, and how to match your index to your query pattern. Every idea is shown with real examples.
Then we move to query rewrites. Small changes in the way you write joins, filters, and expressions can make a slow query suddenly move at top speed. You will pick up a few quick rewrite tricks that make an instant difference.
By the end of the session, you will know how to
• Use wait stats to find the main bottleneck
• Pick better indexes that boost performance
• Rewrite queries for quick speed improvements
• Apply simple rules that make your queries faster than your neighbour’s
A fast, practical, and entertaining session for anyone who wants easy wins in SQL Server performance tuning.
About the speaker
Pinal Dave
SQL Server Performance Tuning Expert
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications. Pinal has authored 15 SQL Server database books and 100 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com. Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.
