Triad SQL Server User Group

The Triad SQL Server Users Group (TSSUG); is a forum where Microsoft SQL Server database administrators and developers meet to learn more about the product, share ideas and make contact with other similar individuals. Our group is run by SQL Server professionals for the benefit of anyone interested in participating in the group.
All of our meetings are free and open to anyone who is interested in sharing their knowledge of SQL Server. Our meetings are generally held on the last Tuesday of every other month, unless otherwise noted. Food is no longer being provided, however you are welcome to bring in your own.


Next Meeting: Thu, Nov 10 2011

SQL Internals - Indexes

Language: English
Event Type: In-Person
Online Meeting URL: None

SQL Internals - Indexes


UTC : Thu, Nov 10 2011 23:00 - 02:00
Event Time : Thu, Nov 10 2011 18:00 - 21:00 (UTC-05:00) Eastern Time (US & Canada)
Your Local Time: Thu, Nov 10 2011 23:00 - 02:00


4821 Koger Blvd
Greensboro, North Carolina

Direction: None

Featured Presentation

SQL Internals - Indexes

Speaker: Kevin Goode, Director of Platform Engineering Inmar

Summary: Learn how SQL Server Indexes work from the inside out. This session will explain what a B+Tree index is and how it is structured on data pages. We will look at the differences in how a clustered index and a non-clustered index is stored and accessed. Then we will dig a little deeper and use some DBCC commands to look at data pages to see the difference in a leaf level page and intermeadiate pages. Finally we will find out if a clustered index is truly stored in row order.

About Kevin: Kevin Goode is an MCSE, MCSD, and MCDBA. Currently, he is the Senior Data Architect for Inmar Inc. Kevin has over 12 years SQL Server experience starting with 6.5 and 15 years of IT experience. He has worked in many industries including manufacturing, distribution and logistics, financial services, IT outsourcing and has worked for several fortune 500 companies. His specialties include SQL Server development, Performance Tuning, Business Intelligence, and ETL.








Back to Top