A Tour in The Indexing World!
Hossam will be your guided tour to the indexing world! We will visits index types, know where to use them, how they work, interesting facts, and best practices. We will see how to keep our indexes healthy for better performance as well.
Note: This session has some demos that show how using indexing (in the right way) will enhance your query performance.
- Overview about indexing (includes structure, composite index, fill factor and accessing data).
- Clustered Index.
- NonClustered Index.
- Covering Index.
- Filtered Index.
- Keeping Your Index Healthy.
Sorry, there are no downloads available for this session.
Hossam is a Senior Database Architect and has been using SQL Server since version 7.0. He earned MCTS SQL Server 2005/2008, MCITP Database Developer 2008, and MCITP Database Administrator 2008 certificates and recently he become MCT (Microsoft Certified Trainer).
He works as a freelancer Technical Consultant specialized in Database Systems and Performance Tuning. He is known for his Cloud Computing competency as well that he is writing and speaking about since 2009.
Beside being board member in ITdigest and DevLifeStyle communities in Saudi Arabia, he co-founded SQLServerPath.org community where he blogs in English.
Blog (Arabic): www.SaudiGeek.NET | Follow him @SaudiGeekNET | LinkedIn: HossamAlfraih
The video is not available to view online.