22 thoughts on “SQL Server : Index Architecture

  • March 4, 2013 at 12:33 am
    Permalink

    Yes. You have to calculate based on the datatype.

    Reply
  • March 13, 2013 at 7:01 pm
    Permalink

    Sir i Have one question why do we have only one Primary Key per table Please correct me if i am wrong that Pk uses unique index(clustered or nonclustered) to enforce uniqueness but we can create multiple unique indexes per table i want to get the logic is it as per relational db guidelines that a table can only have one Pk or is there any other technical reason ?

    Reply
  • March 27, 2013 at 12:54 pm
    Permalink

    Good video , but i found change in value in leaf level and middle level page last table value is differing 410, 411, why is it so?

    Reply
  • May 4, 2013 at 5:42 pm
    Permalink

    Thank You very much!!! for sharing the knowledge. First time I exactly understood the functionality of Index and their Architecure.

    Reply
  • May 18, 2013 at 9:01 pm
    Permalink

    Please can u explain page splitting after 4060226 rows with intermediate pages

    Reply
  • June 6, 2013 at 8:16 pm
    Permalink

    Awesome Video. Thanks for sharing . It really simplifies the concept of Clustered Index and Non clustered Index .

    Reply
  • June 11, 2013 at 12:46 pm
    Permalink

    Thanks cleary understand index concept

    Reply
  • June 20, 2013 at 6:05 pm
    Permalink

    thank you.

    Reply
  • July 15, 2013 at 2:05 pm
    Permalink

    You can not have more than one cluster index because the data in the table gets changed directly, hence you can not able to create/ have second cluster index in a table.

    Reply
  • August 29, 2013 at 12:55 am
    Permalink

    thank you very much

    Reply
  • October 8, 2013 at 7:51 pm
    Permalink

    if you might explained about fillfactor also it would be good

    Reply
  • October 30, 2013 at 9:50 pm
    Permalink

    You're just too Good, This video really helped me a lot….
    Thanx for Solving my doubt

    Reply
  • November 2, 2013 at 2:53 pm
    Permalink

    nice explained

    Reply
  • January 16, 2014 at 5:35 pm
    Permalink

    You have depth knowledge in Index Structure.Good thank you shring this vedieo.

    Reply
  • January 19, 2014 at 2:06 pm
    Permalink

    I like your videos a lot.on this chapter, it would more understandable if you have picked a ID for example. Please keep posting.

    Reply
  • January 21, 2014 at 1:23 pm
    Permalink

    I love your videos morethan anything ………..

    Reply
  • June 11, 2014 at 11:54 am
    Permalink

    Your Explanation is amazing sir……Thank you very much…….

    Reply
  • January 14, 2015 at 11:07 pm
    Permalink

    Hello Everyone, 

    I added another new course called  “ SQL Server 2012 : Performance Tuning in Action with 100 million + rows”.

     It is going to be started very soon. For complete course description and other details, please contact me at [email protected]

    Technical Highlights:

    • Analyze performance bottlenecks
    • Analyze the SQL query Performance
    • Design an effective index strategy
    • Database Engine Tuning Advisor
    • Analyze Dynamic Management Views (DMVs)
    • Analyze Statistics and Fragmentation levels
    • Diagnose and avoid blocking and deadlocks
    • Analyze execution plans
    • Develop efficient queries and stored procedures
    • Analyze and Design the effective query to INSERT a large volume of data ( 100  Million + rows)
    • Analyze and Design the query to  UPDATE  the large volume of data ( 100  Million + rows)
    • Cursor Cost Analysis vs SET based Analysis
    • Limitations on MERGE statement
    • How to manage and deal with Enterprise Production server issues

    Thanks,
    Kranthi
    Microsoft Certified Professional
    [email protected]

    Reply
  • January 27, 2015 at 4:51 pm
    Permalink

    Good Video to understand indexing concept.

    Reply
  • February 14, 2015 at 11:04 am
    Permalink

    Good One……………..

    Reply
  • December 25, 2016 at 7:03 pm
    Permalink

    Thank you

    Reply
  • February 27, 2018 at 3:17 pm
    Permalink

    Hi Sir,
    Can you provide individual videos on below topics if you have

    Indexes
    Statistics
    Query Processing
    Understanding Execution Plans
    Identifying Query Issues
    Query Performance
    Hints and Plan Guide
    SQL Profiler

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *