Angular, MVC core starting 16.07.20, Every Thursday at 9 PM. Syllabus explained in the video if needed the syllabus do email at questpond@questpond.com. If Interested share this video on your FB, Twitter, and Linkedin and avail today's training free. th-cam.com/video/MblRRqld1fg/w-d-xo.html
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.
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 questpond@questpond.com with the shared link and we will email you the PDF.
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?
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.
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
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 ??????????
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
20+ SQL Server Interview Questions : th-cam.com/video/SEdAF8mSKS4/w-d-xo.html
20 MSBI Interview Questions : th-cam.com/video/Nw_sHEKnOUE/w-d-xo.html
10+ Power BI Interview Questions : th-cam.com/video/Cozc9WNBRt4/w-d-xo.html
SQL Server Joins : th-cam.com/video/KTvYHEntvn8/w-d-xo.html
SQL Step by Step - th-cam.com/video/uGlfP9o7kmY/w-d-xo.html
Software Architecture Interview Questions : th-cam.com/video/AtTgcbLOqMM/w-d-xo.html
Angular Step by Step Tutorial for Beginners : th-cam.com/video/-9VcW7MBDs8/w-d-xo.html
25 Angular Interview Questions : th-cam.com/video/-jeoyDJDsSM/w-d-xo.html
35 Important JavaScript Interview Questions : th-cam.com/video/Zb4dPi7CANU/w-d-xo.html
30 Important C# Interview Questions : th-cam.com/video/BKynEBPqiIM/w-d-xo.html
25+ OOPS Interview Questions : th-cam.com/video/u99wAoBjDvQ/w-d-xo.html
25 Important ASP.NET Interview Questions : th-cam.com/video/pXmMdmJUC0g/w-d-xo.html
20 PHP Interview Questions : th-cam.com/video/1bpNSynUrl8/w-d-xo.html
5 MSBI Interview Questions : th-cam.com/video/5E815aXAwYQ/w-d-xo.html
20 MySQL Interview Questions : th-cam.com/video/9hfjC-BpY20/w-d-xo.html
Either clustered or non-Clustered it creates a Btree structure.
Split happens when its exceed 8 kb page size.
This is awesome. First video which explain how the index make search faster with Example.
Clear and neat explanation. Great job,really appreciate the effort !
simply clear nerration with apt example to grasp. All the best
SQL Server training and interview question:-What is index and how does it make your search faster ?.
👊👊👊👊👊👊Smash Subscribe button if you like it.👊👊👊👊👊👊
I loved it! The explanation was top-notch
Simple and neat!!!!!! Got an interview and this helps!!!!! Thank you sir!!!!!!
This video got me subscribing without even knowing, lol.
In what scenerio do we use non clustered indexes?
Simple ..wot it is , how it is done ..this is wot we need ..amazing
Relly very inspiring sir. Good and go on. You are really an ideal for the future oriented candidates.
Angular, MVC core starting 16.07.20, Every Thursday at 9 PM. Syllabus explained in the video if needed the syllabus do email at questpond@questpond.com.
If Interested share this video on your FB, Twitter, and Linkedin and avail today's training free.
th-cam.com/video/MblRRqld1fg/w-d-xo.html
Thank you, this is a great video! I appreciate the thoroughness and attention to details. Ever consider teaching? Looking forward to more posts!
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.
Something I was searching for a longgg time! Appreciate your efforts behind the video! Thanks! 🙏
You make things easy and digestive ... Thank you so much .
Thank you so much it was very helpful. Clear with a good accent.
Nice. Your diagram made it easy to follow you. Thanks!
Excellent explanation
Thanks it's really clear
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 questpond@questpond.com with the shared link and we will email you the PDF.
Hello pls email me the interview questions
Very clear explanation ...Yu rock....
perfect explanation about B-tree index
you were didn't explain clustered and non-clustered differences
thanks for sharing this video. looking forward to the second part of this video.
beautiful and clear explaination
thanks a lot
Nice language sir and topic explain also
Very well explained
Great video- summarizing the main points.
Thank u so much for making it simple. Is there any video on clustered and non clustered index?
Very well explained. Thank you very much.
Simple and awesome
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?
thank you so much for sharing this vid...you helped me alott!!
i like way of explanation ..very helpful
Thank you so much for this video :)
Thanks! Helped me alot to understand!!
Whenever u upload the video how indexes decreases the performance let me know .Nice video
Thank you for this, really helps a lot!
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.
thanku
Its a good video but a little short,waiting for Clustered & Non Clustered,How to use & where to use etc..
thank you so much sir for explanation appreciate you.
Excellent sir !
Sir, Can you explain clustered and non clustered indexes?
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
Check this th-cam.com/video/HmnQyP8s5O8/w-d-xo.html
This was a great vid :)
Really good explanation :)
Great job! Thanks a million
Nice explanation ..
I assume this structure will be in recursion mode means non leaf node will also have b tree inside.. please confirm
As always the best
Which software are you using
Clever video, clever man ;)
What is difference between
Create table table _name(
And
Create table dbo.Table_name(
plz add a lecture on dominance index or similarity and dissimilarity index
Will forward your request to the technical team. Thanks for your input.
thank you!!
Great Video! Is it possible to adjust the number of non-leaf nodes?
Thank you. ^^
Please explain the Clusterd and Non Clustered index
Do you have same DVD package for Java as well ?
+Digant Shah Yes we have for Java, here is the link with details www.questpond.com/java/javaj2eedesignpattern.html
Thank you very much, really appreciate!
Nice very nice tutorial
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 ??????????
Please tell me... Sql server. will covere all topic of sql..
Below you can check what all topics we have covered in SQL Server course-
www.questpond.com/learn-sql-server-step-by-step/cid9
Thank you!
please let me know how does the data is being divided in root nodes and non leaf nodes.
Where is the follow-up video of this? Can you please help me with the link?
well done!
What does logical reads means ????
thanks for the video
Thanks now I understand how index is fast, lol other than book index pages blah blah explanation!
OUR LOGICAL READ WAS 146431 BEFORE INDEXING, AFTER INDEXING IT CAME TO 5,,THANKS
I have one question here, how to determine root note? I can see here it is 30. But can you explain why only 30?
How does it work in case of String search?
even if the search value was 10, a full table scan would be happen because it doesn't know about later 10th values.
Thank you
Thank you, easy to understand
thanks
what is version of mssql managemnt studio?
What is logical reads?
I would like to ask , how index work in background?
So easy
Awsome!!!!
how can we sort nonclustered index ?
+msstaui DB For Technical query mail us at questpond@questpond.com
Please stop saying "you know." If I knew, I wouldn't be watching your good video.
But you didn't show how sql server creates balance tree?? Please explain
Sir you please provide video on
WCF
WEB API
Angular 4
SVN
Plz explain cursorcand sequences..
Was no covered the difference between: clustered and non-Clustered - anyway, thanks for the video!
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
This microphone is pissing me off. Sorry, but I can't get beyond 0:40 into the video...
better
no one search by ID because they dont know your ID .
Microsoft Access.
So past
clear and have code examples, very good !
thank you