Advanced SQL Server Indexing for DBAs

Summary:

Somehow you managed to get yourself voluntold to take care of the company’s SQL Server installation. Over time, you picked up the basic knowledge of how to use indexes to make queries perform better.

But there are still cases where things just don’t appear to work as expected. Cases where SQL Server seems to ignore existing indexes. Situations where you just can’t figure out how to create a fitting index in the first place.

If that describes you, this session is for you. In it you’ll discover:

What index selectivity is and how it impacts index selection
The ominous “tipping point” and how it can lead to surprising index choices by the optimizer
How to improve Aggregate Performance with indexes
How to improve Join Performance with indexes
Indexes on heaps and the Forwarded Records trap
Filtered Indexes

After attending, you’ll have a set of new tools and techniques in your SQL Server toolbox that you can take home and use to increase performance in your database right away.

So join Kevin Kline and special guest Sebastian Meine, Ph.D. (last seen in our Introduction to SQL Server Indexing webinar) for another interactive session where we take a deeper dive into the power behind indexes in SQL Server!

Interested in additional SentryOne webinars? Check our webinar library.

Available On Demand

Kevin Kline

Principal Program Manager, SentryOne

Kevin (@kekline) serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, and long-time blogger at blogs.sentryone.com/author/kevinkline. As a noted leader in the SQL Server community, Kevin blogs about Microsoft Data Platform features and best practices, SQL Server trends, and professional development for data professionals.

Sebastian Meine, Ph.D.

Founder, Principal Trainer, and Consultantsqlity.net llc

Sebastian Meine, Ph.D. founded sqlity.net in 2010 to fully engage in his passion for SQL Server and help people overcome their SQL Server related challenges.

● Are your customers complaining about slow performance or even timeouts?

● Are your daily reports running all night or even more than 24 hrs?

● Are you thinking about moving your SQL Server to a different data center or the cloud but require zero down-time?

● Are you concerned about compliance with GDPR, CCPA, PCI, or HIPAA?

● Do you worry about SQL Injection attacks, privilege escalation, and other ways for the bad guys to gain access to your data?

● Would you like to get your development team to make fewer mistakes when writing T-SQL code like stored procedures or views?

● Have you considered adding tSQLt to your CI pipeline?

Using his Ph.D. in mathematics and his close to 20 years of experience (first as a software architect at a global Fortune 50 company and then as an independent consultant), these are common challenges that Sebastian loves solving.

Do these questions sound familiar? Let’s schedule a call and see how we can best work together to make these problems go away so you can concentrate on going back to doing what you love.

Webinar: