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.
When & Where
Tampa Bay SQL Users Groups
These are two user groups interested in sharing information about Microsoft SQL Server and related topics.
The Pinellas User group meets at the Juvenile Welfare Board at 6:30pm on the third Tuesday of every month except December. The address is 14155 58th Street North, Clearwater, FL 33760.
The Hillsborough User group meet at Computer Associates at 6:30pm on the last Thursday of every month except December. The address is 10210 Highland Manor Dr, Suite 300, Tampa, FL 33610.
We look forward to seeing you there.