Indexes in SQL Server | Use Indexes for Faster Search in SQL | SQL Interview Questions

For more such videos visit www.questpond.com
For more such videos subscribe ruclips.net/user/questpondvide...
See our other Step by Step video series below :-
For more such videos subscribe / questpondvideos
See our other Step by Step video series below :-
JavaScript Interview Questions: • JavaScript Interview Q...
Learn SQL Server Step by Step tinyurl.com/ja4zmwu
Learn MSBI Step by Step in 32 hours:- goo.gl/TTpFZN
Python Tutorial for Beginners:- • Python Tutorial for Be...
Learn Data Science in 1 hour :- tinyurl.com/y5o7qbau
Learn Power BI Step by Step:- tinyurl.com/y6thhkxw
PHP Interview Questions : • PHP Interview Question...
C# tutorial for beginners(4 hrs):- • C# Tutorial for Beginn...
Learn Azure Step by Step:- • Azure Tutorial for Beg...
Azure AZ-900 fundamentals certification :- • AZ 900 Certification |...
Angular Interview Questions and Answers :- • Angular Interview Ques...
Learn Angular tutorial step by step tinyurl.com/ycd9j895
Learn MVC 5 step by step in 16 hours:- • Learn ASP.NET MVC 5 ( ...
Learn Design Pattern Step by Step goo.gl/eJdn0m
Learn Tableau step by step :- tinyurl.com/kh6ojyo
Preparing for C# / .NET interviews start here • C# Interview Questions...
In this SQL Server training video we will understand what are indexes and how they make your search faster. We also run through the fundamentals of B-tree or balanced tree structure. Its also one of those favourite SQL Server interview questions which is asked in SQL Server interviews.
We are also distributing a 100 page Ebook "Sql Server Interview Question and Answers". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on [e-mail] with the shared link and we will email you the PDF.
-----------------------------------------------------------------------------------------------
For more details :-
🌐 Website : www.questpond.com
📱 Mob. No. : [phone] / [phone] / [phone]
📧Email : [e-mail] / [e-mail] / [e-mail]
Share, Support, Subscribe and Connect us on!!!
RUclips: / questpondvideos
Twitter: / questpond
Instagram : / questpond
Facebook : / questpond
#SQLServerInterviewQuestions #LearnSQLServer #SQLServerQuestions #SQLServerTraining #SQLServerTutorial #WhatareIndexes #StructuredQueryLanguage #IndexesinSQLServer

[@questpondvideos]

20+ SQL Server Interview Questions : ruclips.net/video/SEdAF8mSKS4/видео.html
20 MSBI Interview Questions : ruclips.net/video/Nw_sHEKnOUE/видео.html
10+ Power BI Interview Questions : ruclips.net/video/Cozc9WNBRt4/видео.html
SQL Server Joins : ruclips.net/video/KTvYHEntvn8/видео.html
SQL Step by Step - ruclips.net/video/uGlfP9o7kmY/видео.html
Software Architecture Interview Questions : ruclips.net/video/AtTgcbLOqMM/видео.html
Angular Step by Step Tutorial for Beginners : ruclips.net/video/-9VcW7MBDs8/видео.html
25 Angular Interview Questions : ruclips.net/video/-jeoyDJDsSM/видео.html
35 Important JavaScript Interview Questions : ruclips.net/video/Zb4dPi7CANU/видео.html
30 Important C# Interview Questions : ruclips.net/video/BKynEBPqiIM/видео.html
25+ OOPS Interview Questions : ruclips.net/video/u99wAoBjDvQ/видео.html
25 Important ASP.NET Interview Questions : ruclips.net/video/pXmMdmJUC0g/видео.html
20 PHP Interview Questions : ruclips.net/video/1bpNSynUrl8/видео.html
5 MSBI Interview Questions : ruclips.net/video/5E815aXAwYQ/видео.html
20 MySQL Interview Questions : ruclips.net/video/9hfjC-BpY20/видео.html

[@AP-sb3vl]

Clear and neat explanation. Great job,really appreciate the effort !

[@AkshayBopshetti27]

Something I was searching for a longgg time! Appreciate your efforts behind the video! Thanks! 🙏

[@mineispolson]

This is awesome. First video which explain how the index make search faster with Example.

[@aksandesi1919]

Relly very inspiring sir. Good and go on. You are really an ideal for the future oriented candidates.

[@karankatam6684]

Simple and neat!!!!!! Got an interview and this helps!!!!! Thank you sir!!!!!!

[@soumenr2168]

You make things easy and digestive ... Thank you so much .

[@jonathanzuniga3681]

Thank you, this is a great video! I appreciate the thoroughness and attention to details. Ever consider teaching? Looking forward to more posts!

[@gplus46]

Nice. Your diagram made it easy to follow you. Thanks!

[@RibasFilms]

thank you so much for sharing this vid...you helped me alott!!

[@authoenthu]

Simple ..wot it is , how it is done ..this is wot we need ..amazing

[@dnfvideo]

Either clustered or non-Clustered it creates a Btree structure.
Split happens when its exceed 8 kb page size.

[@maedehshahabi4744]

Thank you so much it was very helpful. Clear with a good accent.

[@questpondvideos]

SQL Server training and interview question:-What is index and how does it make your search faster ?.

[@kingsleyyetoh7283]

This video got me subscribing without even knowing, lol.
In what scenerio do we use non clustered indexes?

[@chandrageetham]

simply clear nerration with apt example to grasp. All the best

[@manojtate9604]

I loved it! The explanation was top-notch

[@nareshar8237]

you were didn't explain clustered and non-clustered differences

[@digant83]

Very well explained. Thank you very much.

[@fastdrive55]

Great video- summarizing the main points.

[@RamSagarMourya]

thanks for sharing this video. looking forward to the second part of this video.

[@thisisgaurang]

Excellent sir !

[@donovan30081995]

Thank you so much for this video :)

[@venkataprasadkistam2705]

beautiful and clear explaination
thanks a lot

[@its_bijay_adhikari]

Thanks! Helped me alot to understand!!

[@thingsinthebox]

clear and have code examples, very good !

[@mohammedroshid7922]

Great job! Thanks a million

[@vison819]

perfect explanation about B-tree index

[@laurarankin4663]

Thank you!

[@sureshborade5671]

Nice explanation ..

[@bibigabuyo1654]

Thank you for this, really helps a lot!

[@anilsthanam409]

Excellent explanation

[@sidharthmandal9957]

I have one question..in the B_TREE structure. How come it is defining the range? like in the root node it is -----> [ 30 | 50 ] ??? how come it is defined?

[@chiggrens_playground3193]

Thank you very much, really appreciate!

[@sanjeebamat4485]

thank you so much sir for explanation appreciate you.

[@udayakula3664]

Very clear explanation ...Yu rock....

[@questpondvideos]

👊👊👊👊👊👊Smash Subscribe button if you like it.👊👊👊👊👊👊

[@fayechang8647]

Thanks it's really clear

[@fatfati_wale]

i like way of explanation ..very helpful

[@crummmycheese]

As always the best

[@vandanasuryawanshi2213]

Thank u so much for making it simple. Is there any video on clustered and non clustered index?

[@showyou1197]

Simple and awesome

[@JanekBaranek]

Clever video, clever man ;)

[@malayshah8421]

Really good explanation :)

[@creativestatus9820]

thanku

[@danew637]

thanks for the video

[@ynevet]

well done!

[@Kuraby]

thank you!!

[@prakashpasupathy1612]

Shiv, good video and I gained better understanding on Indexes. Thanks shiv.
1) You've said that Indexes create B-Tree, This is applicable for clustered index right for non-clustered index it won't create B-Tree right?
2) You've said, while creating index, it creates B-Tree and which in-turn organizes the data in B-Tree fashion. so on what basis the split happens? means how split of data happen?
Thanks,
Prakash.

[@sagittariusguy2011]

Awsome!!!!

[@databaseknowledge465]

Very well explained

[@srikanthsurabhis]

Thank you

[@SuperFrankbob]

Great Video! Is it possible to adjust the number of non-leaf nodes?

[@JeraldJamesCapao]

Thank you. ^^

[@jyotibarasker2792]

Whenever u upload the video how indexes decreases the performance let me know .Nice video

[@ipsitapani8641]

Nice very nice tutorial

[@AjaySingh-dr5ry]

Nice language sir and topic explain also

[@excessreactant9045]

This was a great vid :)

[@ulysses1904]

Great videos, I appreciate the time and effort and the fact that they are free and educational. But I would like to offer some constructive criticism as it's always surreal to hear advanced technical presentations interspersed with "right?", "what do you call", etc. Also I have to ask, is the word "only" pronounced "one-ly" in some places or is that an error? Otherwise thank you for making this material available.

[@katiatkachenko5349]

thank you

[@nature_mm-v3w]

thanks

[@pankajpatel2456]

please let me know how does the data is being divided in root nodes and non leaf nodes.

[@ghanshamkashyup6235]

So easy

[@narojunaresh8437]

Sir, Can you explain clustered and non clustered indexes?

[@nareshar8237]

I have one question.
I am using SQL Server2014 version.
Before creating index I am trying fetch 14th record in a table, I have seen that in logical record appearing as 1.
But after creating Index I am trying to search the same 14 th record and in logical record appearing as 2.
Could please explain me this differences ??????????

[@lovefor011]

I assume this structure will be in recursion mode means non leaf node will also have b tree inside.. please confirm

[@jayakottam]

Thank you, easy to understand

[@asifshaik5244]

Please explain the Clusterd and Non Clustered index

[@7to7media]

What is difference between
Create table table _name(
And
Create table dbo.Table_name(

[@prasunjeetsoni6143]

please make a video in normalization deep analysis.. coz I tried to learn it many times bt i could not understand after 3 NF .. Coz the mentor change the schema .. I want to know in a single schema .. if possible then Use Northwind for that... Thanks

[@questpondvideos]

Check this ruclips.net/video/HmnQyP8s5O8/видео.html

[@MrNoomiali]

Thanks now I understand how index is fast, lol other than book index pages blah blah explanation!

[@hayat1410]

Its a good video but a little short,waiting for Clustered & Non Clustered,How to use & where to use etc..

[@itipriya9224]

plz add a lecture on dominance index or similarity and dissimilarity index

[@questpondvideos]

Will forward your request to the technical team. Thanks for your input.

[@sidhant251]

Which software are you using

[@ErJanardhanJethi]

How does it work in case of String search?

[@questpondvideos]

Angular, MVC core starting 16.07.20, Every Thursday at 9 PM. Syllabus explained in the video if needed the syllabus do email at [e-mail].
If Interested share this video on your FB, Twitter, and Linkedin and avail today's training free.
ruclips.net/video/MblRRqld1fg/видео.html

[@lovefor011]

what is version of mssql managemnt studio?

[@rohitsotra2010]

I have one question here, how to determine root note? I can see here it is 30. But can you explain why only 30?

[@vipulshahi7552]

better

[@harmanpreetkaur5910]

Plz explain cursorcand sequences..

[@digant83]

Do you have same DVD package for Java as well ?

[@questpondvideos]

+Digant Shah Yes we have for Java, here is the link with details www.questpond.com/java/javaj2eedesignpattern.html

[@ynevet]

even if the search value was 10, a full table scan would be happen because it doesn't know about later 10th values.

[@saispark4934]

OUR LOGICAL READ WAS 146431 BEFORE INDEXING, AFTER INDEXING IT CAME TO 5,,THANKS

[@gkmishra2009]

Sir you please provide video on
WCF
WEB API
Angular 4
SVN

[@archanasaini5227]

I would like to ask , how index work in background?

[@rohith.mohansai]

Where is the follow-up video of this? Can you please help me with the link?

[@nivethithanivetha921]

What does logical reads means ????

[@SurendraTarai]

What is logical reads?

[@shivanishubham5575]

But you didn't show how sql server creates balance tree?? Please explain

[@Ganeshay-996]

Please tell me... Sql server. will covere all topic of sql..

[@questpondvideos]

Below you can check what all topics we have covered in SQL Server course-
www.questpond.com/learn-sql-server-step-by-step/cid9

[@questpondvideos]

We are also distributing a 100 page Ebook "Sql Server Interview Question and Answers". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on [e-mail] with the shared link and we will email you the PDF.

[@bharathreddygali]

Hello pls email me the interview questions

[@nature_mm-v3w]

how can we sort nonclustered index ?

[@questpondvideos]

+msstaui DB For Technical query mail us at [e-mail]

[@tyronesunde8314]

Please stop saying "you know." If I knew, I wouldn't be watching your good video.

[@RahulKumar-vr4cm]

Microsoft Access.

[@manueljordan317]

Was no covered the difference between: clustered and non-Clustered - anyway, thanks for the video!

[@saitejaaa1086]

Cluster means only we apply one condition on one table after using cluster index it will Start sorting the Id .
Non cluster means we will apply the multiple columns in a single table by using the index

[@krishan63]

So past

[@atvo2950]

no one search by ID because they dont know your ID .

[@Censtudios]

This microphone is pissing me off. Sorry, but I can't get beyond 0:40 into the video...