I did multiple certifications on SQL from reputed online learning platforms and even bought advance SQL courses on Udemy but even they do not teach these things. Hats off to you, it's because of your videos I go super confident in my interviews now.
Sir, please make video on INCLUDE(columns) along with non clustered index and why we don ot use it on clustered index. That is very important operation while optimizing query cuz large description(nvarchar(max)) colums slows down non clustered indexes too when they are in the select
Hi Kudvenkat, I wonder if this series will be continued? or if the continued series is moved to other platform because I found your tutorial is very easy to understand and very helpful. Will looking for buy a online course regarding this topic if you're going to publish one
Excellent explanation of these key concepts of sql server indexes and analyzing query execution plans. I am looking for more videos about other query plans such as nested lookups.
Hello Venkat, Nice videos you have in all your playlists. I have a little confusion though. Like you explained that data rows get stored in leaf nodes in Clustered index, where do actual data rows get stored in Non clustered index ? All I see are row locators on leaf nodes which I am guessing are row ID based on which RID lookups get created. Also need little elaboration on key values. Thanks.
Hi Venkat, thanks for the great content! Can I clarify with you, if there's no clustered index key, how does SQL do a row ID look up? Since the heap is not sorted in any particular order, when doing a row ID look up, does it imply a full table scan?
when we don't provide a clustered index. RID lookup happens because the engine by default creates a RID for all rows and stores them by increasing order of RID. But if we have clustered index on Id, then data is already stored in increasing order of id. Now key lookup happens. Key point is that, lookup has to happen on ordered data. RID/KEY fulfills the same purpose.
Hi Kudvenkat, I've been waiting for your series on SQL Server performance tuning for a long time. And you are doing awesome work on this. Please try to make this series for each physical operator of the execution plan and explain the reason behind them and what changes on SQL queries can avoid these heavy operators.
Hello Sir, Thank you for the detailed explanation. Quick query, please? The non-clustered index has been created based on the "Name" column only. How is the RowId column been stored in the index as a key-value pair, please? The RowId column is not even a column in the table. Also, this is table doesn't have a Primary Key column defined, then how does the RowId column has been stored in the non-clustered index, please? Could we expect more videos related to SQL Queries tuning, please?
So the RID is kind of like a primary key which is internally created by sql server for indexing purposes only as there is no primary key given by the user in the table, Right?.
@@Csharp-video-tutorialsBlogspot if you could do some videos explaining about what is table partitioning and how it is done, that would be really helpful.
Is it a good practice to include the pk value in the section INCLUDE of a nonclustered index? Sometimes we want to know which is the table’s id for a certain indexed column and to avoid a key lookup we could read it from the index itself, is it a good idea?
I have question: if we only use nonclustered-index , then data is not sorted in the leaf node, then we use RID to look up , do we have to go to each page to know which data row in which page is equal to the RID that we use in the index tree ?
You are an awe-inspiring🤗 Can you teach us how to analyze a system and convert requirements to ERD 🌟 or anyone recommend me any source to understand this topic well.
This is very nice. Can you create a video with composite index? Like how the data is seek/scan when you have composite index on (col1, col2) but you’re only searching by col2.
Hi, Venkat I have registered for few courses on your website but none of courses have been started yet. I even dropped a mail regarding the same but no response from your end.
Hello YIC - Very sorry, there are just too many emails and did not get time to get to them yet. Sorry, did not mean to ignore. Thank you for understanding. Can you please share the course page URL here and I will be able to help. Hope you are finding our videos useful.
I did multiple certifications on SQL from reputed online learning platforms and even bought advance SQL courses on Udemy but even they do not teach these things. Hats off to you, it's because of your videos I go super confident in my interviews now.
I will pray for you in my whole life whenever I write index. Huge respect sir, can't explain what you have given to me.
You are best sir.
Completely different level of teaching.
I have watched all your SQL videos.
And got a good job.👏👏👏👌👌👌
Mr.kudvenkat is a super hero😎
This is the best explanation I've ever seen. Thanks a ton Sir.
Requesting you to kindly complete the series for SQL Server Performance Tuning Videos
Sir, please make video on INCLUDE(columns) along with non clustered index and why we don ot use it on clustered index. That is very important operation while optimizing query cuz large description(nvarchar(max)) colums slows down non clustered indexes too when they are in the select
you are the best Venkat. I am loving this series, waiting for the next one bro
Thank you so much, Sir. The Perforformance Tuning Playlist is amazing. Really learnt a lot, appreciate your efforts.
Hi Kudvenkat, I wonder if this series will be continued? or if the continued series is moved to other platform because I found your tutorial is very easy to understand and very helpful. Will looking for buy a online course regarding this topic if you're going to publish one
I love this video. Thank you so much! In fact, a lot of BI developers don't event know what RID lookup, Key lookup and parameter sniffing are.
I would like to thank you for all the effort I have learned so much from you.
Thanks Venkat for valuable information in simple way. I love and learned. Keep making valuable videos.
Excellent explanation of these key concepts of sql server indexes and analyzing query execution plans. I am looking for more videos about other query plans such as nested lookups.
Super expert in explaining the tutorial to beginners keep it up and keep going venkat appreciate your efforts 👍
Really Great! Thank you! God will bless you more because you are helping all.
Hi Sir, I have been waiting for more videos of yours on this playlist.
Hello Venkat,
Nice videos you have in all your playlists.
I have a little confusion though.
Like you explained that data rows get stored in leaf nodes in Clustered index, where do actual data rows get stored in Non clustered index ? All I see are row locators on leaf nodes which I am guessing are row ID based on which RID lookups get created. Also need little elaboration on key values.
Thanks.
Hi Venkat, thanks for the great content! Can I clarify with you, if there's no clustered index key, how does SQL do a row ID look up? Since the heap is not sorted in any particular order, when doing a row ID look up, does it imply a full table scan?
What an explanation you are such an inspiration sir, today all my doubts are clear. Thank you
You are very welcome Harshit. Thank you for the feedback. Really glad you have found it useful.
when we don't provide a clustered index. RID lookup happens because the engine by default creates a RID for all rows and stores them by increasing order of RID. But if we have clustered index on Id, then data is already stored in increasing order of id. Now key lookup happens. Key point is that, lookup has to happen on ordered data. RID/KEY fulfills the same purpose.
Excellent explanation. Thank you for creating and sharing these great videos with the world! I also like length of the videos. 5-7 minutes is perfect.
Hi Kudvenkat,
I've been waiting for your series on SQL Server performance tuning for a long time. And you are doing awesome work on this. Please try to make this series for each physical operator of the execution plan and explain the reason behind them and what changes on SQL queries can avoid these heavy operators.
Absolutely Gagandeep. That's the plan. Great suggestion. Thank you.
Nice Explanation Venkat ,Thanks For come Back with New Topics....
This is a great demo. Truly enjoyed your video.
Appreciate your quality content. Thanks
very easy to learn. Learnt a lot from your videos.
Thanks so much for the break down!
Thank you so much your vedios are very helpful than any other vedios
Hello Sir, Thank you for the detailed explanation. Quick query, please?
The non-clustered index has been created based on the "Name" column only. How is the RowId column been stored in the index as a key-value pair, please? The RowId column is not even a column in the table. Also, this is table doesn't have a Primary Key column defined, then how does the RowId column has been stored in the non-clustered index, please?
Could we expect more videos related to SQL Queries tuning, please?
So the RID is kind of like a primary key which is internally created by sql server for indexing purposes only as there is no primary key given by the user in the table, Right?.
Absolutely. Spot on. It would have been good if I mentioned this. Thank you. You summarised it really well. Thank you for sharing.
@@Csharp-video-tutorialsBlogspot if you could do some videos explaining about what is table partitioning and how it is done, that would be really helpful.
@@karthik1090 yes I am also waiting
I really enjoying while watching your videos Excellent
Very good video series. Thanks a lot.
HI SIR, ARE WE GOING TO HAVE MORE VIDEOS ON THIS SERIES, LOOKING FORWARD TO SOME EXCELLENT QUALITY CONTENT FROM YOUR SIDE
another best serie turtorial thank you , you are my best teacher
Please do continue to post more videos.
Is it a good practice to include the pk value in the section INCLUDE of a nonclustered index? Sometimes we want to know which is the table’s id for a certain indexed column and to avoid a key lookup we could read it from the index itself, is it a good idea?
I have question: if we only use nonclustered-index , then data is not sorted in the leaf node, then we use RID to look up , do we have to go to each page to know which data row in which page is equal to the RID that we use in the index tree ?
Next level. You are superb sir.
we hope you can continue this playlist
Excellent videos. Thank you so much.
Thanks a Ton Venkat Sir.
You are an awe-inspiring🤗
Can you teach us how to analyze a system and convert requirements to ERD 🌟 or anyone recommend me any source to understand this topic well.
This is very nice. Can you create a video with composite index? Like how the data is seek/scan when you have composite index on (col1, col2) but you’re only searching by col2.
Hi sir,
We are waiting for partition table concept in sql query performance.
Thanks you sir
I am waiting for more videos of optimization
Sir Please Please Make series for SQL Server performance tuning ! we are obliged to you
Thank you sir for everything 🙏
Hi,
Please help with difference between In and Exists. And its impact on performance
Nicely explained. Thank you
This mean for small table we don't have to worry sql engine will handle by its own.
why explicitly create a new clustered index on the PK?
Venkat why don't you update your excellent playlist on C# to reflect the updates for version 9.0 of the language?
Hello Luigi - Great. Suggestion. Thank you. Sure I will update it soon with all the latest and latest stuff.
The best!
really super bro
Good explanation 👍
Hi Bro Please help us on How to get a best execution plan
Awesome !!
I can not show the green text of the missing index .. any one can help?
can you post on sql sharding and partitioning difference
Very nice
Sir please upload crystal report and report viewer series.. Thanks a lot
Hi, Venkat I have registered for few courses on your website but none of courses have been started yet. I even dropped a mail regarding the same but no response from your end.
Hello YIC - Very sorry, there are just too many emails and did not get time to get to them yet. Sorry, did not mean to ignore. Thank you for understanding. Can you please share the course page URL here and I will be able to help. Hope you are finding our videos useful.
Wow 😍
Thanks sir
please explain column store index
🙏
waiting for Execution plan video
nice and great
🙏