17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor

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.

Agenda:
  • Overview about indexing (includes structure, composite index, fill factor and accessing data). 
  • Heap.
  • Clustered Index.
  • NonClustered Index.
  • Covering Index.
  • Filtered Index.
  • Keeping Your Index Healthy.
  • Q&A.
Note: This session has some demos that show how using indexing (in the right way) will enhance your query performance.
Presented by Hossam Alfraih at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Hossam_Alfraih.png
    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
    http://www.SaudiGeek.NET http://feeds.feedburner.com/-HossamAlfraihakaSaudigeeknetBlog/
  • Video
    The video is not available to view online.
  • Session Files Explorer
    The network name cannot be found.