Dmitri Korotkevitch presents Everything you always wanted to know about indexes but were afraid to ask

Clearwater, FL

Bummer! Sales have ended.

Unfortunately, tickets for this event are no longer on sale.

View upcoming events Create an event

Event Details

No system ever performs well even on the most powerful hardware unless the database is efficiently indexed. But what does "efficient indexing" mean? Database Professionals impress customers by use of magic buzzwords such as “Indexing strategies” and “Performance tuning” and happily contribute to the myth that those are very complex subjects. But with all complexity involved it’s not Rocket Science – the key point is to understand how SQL Server works with indexes and look at them from SQL Server standpoint.  Every system is unique however the main principles remain the same and can be applied everywhere.

In this session Dmitri dives into the internals of Storage Engine and Query Optimizer and covers various topics related with indexes. He talks about physical structure of the indexes; explains how and when SQL Server uses them; demonstrates what patterns lead to index fragmentation and, most importantly, discusses how to design efficient indexing strategies for the system.

Dmitri Korotkevitch is a Microsoft SQL Server MVP, MCITP (Database Developer, DBA) and MCPD. He has 16 years of experience in the industry including more than 10 years working with Microsoft SQL Server.
Dmitri is Director of Development at Actsoft, a Tampa, FL based company developing Data collection, GPS Tracking and Mobile Workforce Management solutions. He is responsible for the architecture, design and development of the database backend handling a sustained load of 3000TPS.   
 

Food and drinks will be provided. As usual there will be SWAG at the end of the meeting.

Our meetings are free and open to the public. The doors open at 6:00 pm and food arrives shortly after that allowing time to grab something to eat and networking with your peers. The meeting will start at 6:30 with announcements and open floor discussions followed by the speaker for the night.

Please plan on joining us for the meeting after the meeting where we can network at Courtside Grille.