The DBA Fundamentals VG offers training and support to individuals interested in a solid DBA foundation.

Sign in to Subscribe

Meeting Details
Ayman El-Ghazali - Indexing Fundamentals

Wed, Jul 10 2013 16:00 UTC

Indexing Fundamentals

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.

Ayman El-Ghazali

Ayman is a passionate SQL Server DBA, Developer, and Business Intelligence Developer. His passion for technology started when he was a young boy playing DOS games on his father's computer. From there, he moved up to computer programming in high school and went on to get B.S. and M.S. degrees in Information Systems from Drexel University in Philadelphia. He has worked with the SQL Server product since 2006 and has experience with SQL 2000 through SQL 2012. He holds MCSE Data Platform, MCSA SQL 2012, and MCITP SQL 2008 DBA certifications and is also a Microsoft Certified Trainer (MCT). He has been active with the virtual chapters of PASS, participating in online training and also giving presentations. He is fluent in Arabic, a huge football(soccer) fan, and is always looking forward to learn more about SQL Server, SQL Server BI, and technology in general.

Back to Top