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.
@shahabhaidar
3 жыл бұрын
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
@shuvo9131
3 жыл бұрын
you are the best Venkat. I am loving this series, waiting for the next one bro
@ashajyothi06
3 жыл бұрын
Mr.kudvenkat is a super hero😎
@mgstar6041
3 жыл бұрын
I would like to thank you for all the effort I have learned so much from you.
@vishaljhaveri7565
9 ай бұрын
Thank you so much, Sir. The Perforformance Tuning Playlist is amazing. Really learnt a lot, appreciate your efforts.
@sarfarazmakandar4684
3 жыл бұрын
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.
@adorebeauty6539
3 жыл бұрын
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
@kalaicompute
3 жыл бұрын
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.
@georget10i
3 жыл бұрын
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.
@ninaddesai8846
2 жыл бұрын
You are best sir. Completely different level of teaching. I have watched all your SQL videos. And got a good job.👏👏👏👌👌👌
@sltrains
Жыл бұрын
Very good video series. Thanks a lot.
@swathivasireddy1601
3 жыл бұрын
Thank you so much your vedios are very helpful than any other vedios
@CK-bu5wh
Жыл бұрын
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
@karthik1090
3 жыл бұрын
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
3 жыл бұрын
Absolutely. Spot on. It would have been good if I mentioned this. Thank you. You summarised it really well. Thank you for sharing.
@karthik1090
3 жыл бұрын
@@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.
@vinish.maurya
3 жыл бұрын
@@karthik1090 yes I am also waiting
@adityasethi9794
2 жыл бұрын
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.
@dp-bhatt
2 жыл бұрын
Excellent videos. Thank you so much.
@abdogebril3525
3 жыл бұрын
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.
@ajay_jangra
3 жыл бұрын
Thank you sir for everything 🙏
@CharlieBrown0507
3 жыл бұрын
Nicely explained. Thank you
@nehakesari7190
3 жыл бұрын
This mean for small table we don't have to worry sql engine will handle by its own.
@ramamohankota007
Жыл бұрын
really super bro
@jasonngan5747
Жыл бұрын
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?
@viveksingh-xl2ut
2 жыл бұрын
Sir Please Please Make series for SQL Server performance tuning ! we are obliged to you
@TechandArt
3 жыл бұрын
Good explanation 👍
@ankuranandwc
2 жыл бұрын
HI SIR, ARE WE GOING TO HAVE MORE VIDEOS ON THIS SERIES, LOOKING FORWARD TO SOME EXCELLENT QUALITY CONTENT FROM YOUR SIDE
@OmkarNandgaonkar
4 ай бұрын
The best!
@kenji2787
3 жыл бұрын
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.
@gauravtiwari6392
6 ай бұрын
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.
@ThanhPhamTien-vr4gf
7 ай бұрын
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 ?
@piraviperumal2544
3 жыл бұрын
Awesome !!
@gagandeepsingh6126
3 жыл бұрын
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.
@Csharp-video-tutorialsBlogspot
3 жыл бұрын
Absolutely Gagandeep. That's the plan. Great suggestion. Thank you.
@TheUjjwalpandey
5 ай бұрын
Appreciate your quality content. Thanks
@murugesankgm1297
3 жыл бұрын
Very nice
@karthikg108
2 жыл бұрын
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?
@akashagarwal6390
2 жыл бұрын
why explicitly create a new clustered index on the PK?
@blackisblack22
Жыл бұрын
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?
@epuriraghavendra3847
Жыл бұрын
please explain column store index
@dhirajkr3758
3 жыл бұрын
Thanks Venkat for valuable information in simple way. I love and learned. Keep making valuable videos.
@mohamedasem6523
10 ай бұрын
we hope you can continue this playlist
@linsfunbox4052
3 жыл бұрын
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.
@vinish.maurya
3 жыл бұрын
Hi sir, We are waiting for partition table concept in sql query performance. Thanks you sir
@kithiyongideon1629
2 жыл бұрын
Really Great! Thank you! God will bless you more because you are helping all.
@sravankumar1767
3 жыл бұрын
Nice Explanation Venkat ,Thanks For come Back with New Topics....
@avinashbhalke4653
3 жыл бұрын
Hi, Please help with difference between In and Exists. And its impact on performance
@ayushisingh2139
Жыл бұрын
Hi Sir, I have been waiting for more videos of yours on this playlist.
@veerandarla9147
3 жыл бұрын
I really enjoying while watching your videos Excellent
@dreamvallyhasan4807
3 жыл бұрын
Sir please upload crystal report and report viewer series.. Thanks a lot
@ypwygk652
2 жыл бұрын
I can not show the green text of the missing index .. any one can help?
@justvenkyy...3423
3 жыл бұрын
can you post on sql sharding and partitioning difference
@ravichandraak8727
3 жыл бұрын
Super expert in explaining the tutorial to beginners keep it up and keep going venkat appreciate your efforts 👍
@satyamahesh89
3 жыл бұрын
Wow 😍
@elainemayer8978
2 жыл бұрын
This is a great demo. Truly enjoyed your video.
@nareshbuddy9522
3 жыл бұрын
Hi Bro Please help us on How to get a best execution plan
@mosespeter9711
Жыл бұрын
Thanks so much for the break down!
@cuteiffatfatima
3 жыл бұрын
I am waiting for more videos of optimization
@hiphen2263
3 жыл бұрын
another best serie turtorial thank you , you are my best teacher
@kssrikanth7905
2 жыл бұрын
very easy to learn. Learnt a lot from your videos.
@satishk4u
2 жыл бұрын
🙏
@Kalpesh812
3 жыл бұрын
🙏
@siddardhasam820
2 жыл бұрын
Please do continue to post more videos.
@LuigiZambetti
3 жыл бұрын
Venkat why don't you update your excellent playlist on C# to reflect the updates for version 9.0 of the language?
@Csharp-video-tutorialsBlogspot
3 жыл бұрын
Hello Luigi - Great. Suggestion. Thank you. Sure I will update it soon with all the latest and latest stuff.
@alankarsrivastava5328
3 жыл бұрын
waiting for Execution plan video
@agrim8863
3 жыл бұрын
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.
@Csharp-video-tutorialsBlogspot
3 жыл бұрын
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.
@sagarverma1250
3 жыл бұрын
Next level. You are superb sir.
@jitendrarankawat9803
3 жыл бұрын
nice and great
@umerwaqas5943
3 жыл бұрын
Thanks sir
@harshitsrivastava9738
3 жыл бұрын
What an explanation you are such an inspiration sir, today all my doubts are clear. Thank you
@Csharp-video-tutorialsBlogspot
3 жыл бұрын
You are very welcome Harshit. Thank you for the feedback. Really glad you have found it useful.
Пікірлер: 77