RSS

Daily Archives: July 3, 2013

Indexing Fundamentals Presentation

Indexing Fundamentals Presentation

**This Session has been rescheduled for July 10th @ Noon EST (16:00 UTC)**

On July 10th 2013 @ Noon EST (16:00 UTC) I will be giving a presentation with the Professional Association for SQL Server (PASS) DBA Fundamentals Virtual Chapter. Entrance is free as always and details can be found at http://fundamentals.sqlpass.org.

Code, Slides, and other information about the presentation will be under the Presentations section of this site afterward. Hope to see you there!

Abstract: Indexing is an integral part of SQL Performance and Architecture. In this presentation we will cover the basics of Clustered and Non-Clustered Index structure and function. Additionally, we will discuss the B-Tree structure, index density (fill factor), page splits, and performance considerations. Finally, there will be a brief discussion of index maintenance.

Advertisements
 

Tags: , , , , , ,

 
%d bloggers like this: