Previous Office design for BDO: Bristol
Next MILANO 8 ITALIAN ARCHITECTS - Office design in China

23 Comments

  1. Kranthi Kumar
    March 4, 2013
    Reply

    Yes. You have to calculate based on the datatype.

  2. AVD072
    March 13, 2013
    Reply

    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 ?

  3. Mubin Shaikh
    March 27, 2013
    Reply

    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?

  4. Ashish Ghildiyal
    March 31, 2013
    Reply

    Thank you Sir

  5. Amir Haroon
    April 26, 2013
    Reply

    Thanks for uploading the video.

  6. vijay kumar Kallempudi
    May 4, 2013
    Reply

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

  7. SambaShiva Reddy
    May 18, 2013
    Reply

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

  8. Risshi G
    June 6, 2013
    Reply

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

  9. sunil Chindarkar
    June 11, 2013
    Reply

    Thanks cleary understand index concept

  10. SambaShiva Reddy
    June 20, 2013
    Reply

    thank you.

  11. reddymrk76
    July 15, 2013
    Reply

    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.

  12. Prakash Mahalle
    August 29, 2013
    Reply

    thank you very much

  13. sarath chandra
    October 8, 2013
    Reply

    if you might explained about fillfactor also it would be good

  14. Abhishek Yadav
    October 30, 2013
    Reply

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

  15. Haja MK
    November 2, 2013
    Reply

    nice explained

  16. Ashok Naik
    January 16, 2014
    Reply

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

  17. sql kumar
    January 19, 2014
    Reply

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

  18. Hayath Syed
    January 21, 2014
    Reply

    I love your videos morethan anything ………..

  19. samba shiva
    June 11, 2014
    Reply

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

  20. Kranthi Kumar
    January 14, 2015
    Reply

    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 kranthi.sqlserver@gmail.com.

    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
    Kranthi.sqlserver@gmail.com

  21. Rajkumar Pomaji
    January 27, 2015
    Reply

    Good Video to understand indexing concept.

  22. sri Srinu
    February 14, 2015
    Reply

    Good One……………..

  23. Janinder Rana
    December 25, 2016
    Reply

    Thank you

Leave a reply

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