SQL Server Indexing for Developers and Accidental DBAs

Summary:

So you have been tasked with making that query faster. You know that indexes often can help with query performance, but how do you even start going about it?

Join Kevin Kline and special guest Sebastian Meine, Ph.D. for this truly interactive session and discover how indexes in SQL Server work. After attending, you’ll be able to answer common index questions, like:

Which columns should I add to my index?
How many indexes should I add to my new table?
Does the column order in my index have to match that in my query?
Does it hurt to have too many indexes?
When should I consolidate Indexes?
Are there queries that get slower after I create an index?

But even more important, you’ll be able to explain how indexes are organized in SQL Server and what mechanism is responsible for the amazing performance gains you can achieve with them.

Don’t miss this unique session. Attend, and you might just turn into an indexing superstar.

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: