RSS

Tag Archives: index maintenance

Indexing Fundamentals Presentation – Pending Questions Answered

Indexing Fundamentals Presentation – Pending Questions Answered

On July 10th 2013, I gave a presentation with the Professional Association for SQL Server (PASS) DBA Fundamentals Virtual Chapter. The topic was Indexing Fundamentals and there were some questions that we did not have time to answer. I have combined similar questions and given one answer to cover the specific topic.

If you missed the presentation, you can click HERE to see the recording.

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.

Read the rest of this entry »

Advertisements
 

Tags: , , , , , ,

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.

 

Tags: , , , , , ,

 
%d bloggers like this: