Indexes in sql server Part 35

In this video we will learn about
What are indexes
Why do we use indexes
Advantages of indexes
These concepts are applicable to sql server 2000, 2005 and 2008
Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our CZcams channel. Hope you can help.
/ @aarvikitchen5572
Text version of the video
csharp-video-tutorials.blogspo...
Slides
csharp-video-tutorials.blogspo...
All SQL Server Text Articles
csharp-video-tutorials.blogspo...
All SQL Server Slides
csharp-video-tutorials.blogspo...
All Dot Net and SQL Server Tutorials in English
czcams.com/users/kudvenka...
All Dot Net and SQL Server Tutorials in Arabic
/ kudvenkatarabic

[@solifaspearsesalimu4865]

Respect to this guy. I'm employable because of his tutorials

[@MarianoGianni1]

Same xd

[@aaronaaronaaron5922]

🙋🏽‍♂️ same

[@harshpatel-wr1jl]

same,,,,

[@Anask_M]

Me too

[@chetnasrivastav2691]

Hii

[@Salty_Matter]

Can we send Venkat a recognition award or something? I have never fallen in love with SQL, this guy makes it so simple to understand.

[@KumarAnalytic]

why not

[@kalingasarangi3584]

Dear venkat, I went through your all the sql tutorial vedios. you are the best online teacher..I just want to thank you for your time and efforts for these vedios.

[@inayathussaintoorie]

Only Thanks is not enough for you. You deserve a lot. I have been watching videos from 1 to 35 for this course. You are just awesome. God bless you man.

[@amruthavarshinichaganti5667]

Why are you watching just 1 to 35?

[@dev0_018]

@@amruthavarshinichaganti5667 he commented at the video he has reached for now ( this video -> Part 35

[@abhishekpandey190]

My very first source of learning sql was this channel, learner a lot

[@sapnaantara9031]

The best explanation of indexes till now! Thank you so much for this.

[@stillborn007]

You are my hero! Each time I need to check up on some relevant topics, I can find them on your channel.

[@Saadsafeer0]

Thank you so much for helping out the people for free.
#RespectYouSir

[@nasgaroth1]

You are the best man. Keep your education mission ;-) Best Regards ;-)

[@krzysztofs8535]

"We will talk about it in the next session". I go fast to the next session! Thanx Venkat!

[@anuragvashishtha6660]

A good start towards working with Indexes. Eager to learn more on Index, so starting with the next video of the series.
Thank you!

[@krismaly]

Rewatched.
Thanks a lot for educating community

[@captfish93]

Kudvenkat you are awesome. Thank for all your uploads!!!

[@nik08101986]

I just gone through bcos i was asked about the indexes in interview today.... and found this very useful... thanks for sharing

[@krismaly6300]

Revisited to refresh my memory.
Thanks a bunch

[@PS-vc6ef]

Kudvenkat, you are the best!!!!!!!!! CZcams needs to seriously pay you for such a talent!

[@camsebe]

Very well done, Venkat! Thank you for your tutorials!

[@nullifidian13]

You're a brilliant teacher. I greatly appreciate your tutorials🙌

[@tourmaniathought3080]

Excellent work sir .I am able to work as DBA just bcoz of you . hat's off to you..

[@INvestYOU]

perfect Videos for beginners. Thanks Venkat..

[@dimitrix2010]

Clear and detailed presentation. Thank you !

[@rakeshgowda8520]

You are the best online teacher. Kudos brother

[@Shubhamkumar-ir5ox]

Thank you Venkat for the wonderful gift of Knowledge. Good bless you

[@pogococo2246]

Excellent explanation, easy to understand. Thank you!

[@Fcb447]

the best explanation and videos i have never watched before. thanks a lot sir!

[@williamwang2047]

You are the best man. Keep your education mission

[@CH14life]

thank you so much you have made the description so much easier to understand

[@qualityrenov]

thank you for these tutorials

[@richardpalawofski3031]

Very good video for a beginner. Thank you

[@wasE3m1]

Perfect explanation. Many thanks.

[@JohnWaclawski]

Great tutorial! Thank you very much!!

[@ankitsharma-tr3be]

thankyou so much sir..
great explanation....:)

[@sufyanalishani5038]

i like ur teaching style (great teacher ),love from pakistan.

[@danielhunter9301]

This was the best explanation I have heard, thanks Kudvenkat....you are the best.

[@asmaasedeek3464]

nice explanation ....thank you

[@darshanwala5561]

Thank you for create every student to Understand practical with example so a effect for all tutorial. Thank you brother.

[@fernandosanches7111]

I am brazilian and not advanced in English, but I like your videos and the subtitles helps a lot. Thank you.

[@dodukashyap5971]

hi , i really like your all tutorials ,thank you so much to be teach me ,you r the best teacher

[@Shovaan1408]

Thank you for doing this extremely helpful

[@magdagabrielayanezmarin4449]

Really appreciate your contributions :D

[@videos4homies938]

hi dude, i've learnt a lot from u
Greetings from mexico

[@yuvaraniganesh3140]

Best tutorial in CZcams..

[@saikiranguntuku171]

Sir .. Thank you very much.........
For your valuable videos

[@rohinisahajayogini8361]

Awesome explanation .Clearly understood

[@saurabh75prakash]

Very clear and sumple explanation, thanks.

[@ramkr88]

Perfect!
one things i want to know when to use tempdb in development.

[@mohanadhmd]

This is one of the few times I pause the adblock. Keep up the good work. If we can support you and your work in some way, let us know

[@krzysztofs.8906]

Great video. Thank You.

[@TrungNguyen-ld7hz]

This is old, but this is the best course you can find online!

[@dauculajava]

Thank you so much

[@umasakshi4966]

Thanks for sharing. These videos are very helpful

[@harthikgroup7156]

Venkat your communication us wonderfull..nice explanation

[@krismaly]

Concept explained clearly. When user goes to create index in designer menue are changed from Server versions. I think you may be using 2005 or 2008. I am using SQLEXPRESS2012 and it directly defaults the index to Non-Clustered if there are no indexes'. Also if you could mention what would be default for ASC or DES for a column. Pl note I am suggesting not criticizing. I love your videos. I enjoyed this video. Thanks a bunch

[@cecilchampenois7112]

Kudvenkat, you did a great job on this video. Your English is also very good.

[@ynufri]

Thanks for the video, great explanation!

[@NarinderSingh-qe9pe]

Kiril Anastasov 5 6o6

[@gomathil4610]

thank you very much sir☺
video was very helpful

[@poojarj055]

Thanks it helped!

[@afrikabusiness6375]

very clear video. thanks very much.

[@oloruntobaonabiyi6199]

Thanks for all your help! Best SQL Tutor... Was wondering if you have classes on BIG DATA or JAVA

[@biancadragomir]

great video! thank you

[@surekhavani3859]

Thankyou very much sir.it's really understandable

[@gunveetsinghchhabra3272]

thanks alot.. its pretty helpful

[@ASX373]

you are amazing thank you for all the videos

[@videocoll1]

Really sweat teaching !!!!

[@ushmailoveu]

isko bolte h 1 no video tutorial.

[@_JustBeingCasual]

Pretty good video! even nowdays, pretty easy to understand! Only downside is that there is no examples with an without what the performance is and the gain. Though that is not the goal of the video.

[@impossiblehousemarylandsta6266]

Wowwwwwwwwww, thats it, my select query run 50x faster. Sir well done and I appreciate it.

[@Csharp-video-tutorialsBlogspot]

Hi Kerem - Thank you for letting us know. Great news. Indexes are great from a performance standpoint when reading data.

[@varunjain4571]

very nice sir , thankyou for this

[@kinhho1128]

Thank you very much.

[@Blackhole-0]

watching in 2023 ...
wondering how you created such awesome content 11 years ago !!👏

[@user-ho9ge6xh7u]

sir you are great

[@kayaliqbal]

Thanks for your information. solve lot of loading problem

[@kaushikbhadani]

very very nice.

[@jayashreereddy5643]

Great video !!

[@nakulanand2725]

Very useful video thank you

[@VENKATYADAV-c7t]

Nice explanation and very impressed

[@MrTechGeek01]

awesome explanation :)

[@TheShahanasiddiqui]

you are amazing!!

[@adityatomar6231]

i read tens of documents but still couldn't grasp the topic,, watched your video, and boom!!

[@bogdangirdea8929]

very good tutorial. thanx

[@shriramgarje2229]

thank you very much sir

[@SendilP1]

Thanks for the Video ...

[@ShayMor_Marketing]

thank you very much

[@pouremilee]

Man I LOVE YOU.. NO homo..you are a great tutor.

[@tusharkaushik79]

Very nice learning experience

[@gaureesha9840]

You should have mentioned about the binary search that takes place on the separate table that is created with
sorted key values

[@shubhankarpaul2740]

Its a B-TREE not a BST

[@md.aarifansari1957]

nice video sir its very helpful for us

[@abdulhameed5816]

Best tutorial ever

[@Csharp-video-tutorialsBlogspot]

You are very welcome. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.

[@shovikanand3214]

Dear Sir Venkat, u r the best ,urs most honest teaching from basics to high industry level is 0n the TOP among the tutors, mentors eduactors available worldwide & on utubes for c# asp, sql server mvc ..and many more..I wish to see ur face .but cud only hear ur voice...wish u happy healthy long life..u hv done a great work for mankind..in IT ..whether a student is poor or rich ...everyone can get in depth true knowledge from u ..SALUTE u sir

[@dragnar4743]

Amazing video.

[@BijouBakson]

Thank you.

[@musiwalter3214]

thank you for these videos.
i have a general knowledge in computing. do you provide tutorials lessons for those who want to be SQL certified?

[@URG_Creations]

Hello Venkat
thanks for such a great videos.
I have a query.... I am learning Oracle database... can I follow the same videos what you have uploaded on Indexes, stored procedures??
are they same for both Oracle and PL SQL ?

[@learnwithme1201]

Thanks

[@nabilnagi22]

Thank you

[@LifeIsGood1992]

thank you

[@anandsilwal5001]

very nice tutorial

[@Scotty047]

Thank You for video. Is there any video where one can see how indexes are used ? I mean to see how fast became the query

[@moinmukhtar5084]

Best teacher

[@cathrinevishali2270]

what is index fragmentation and defragmentation? How it affects DB performance?