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.
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?
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.
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
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.
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.
👊👊👊👊👊👊Smash Subscribe button if you like it.👊👊👊👊👊👊
simply clear nerration with apt example to grasp. All the best
Clear and neat explanation. Great job,really appreciate the effort !
I loved it! The explanation was top-notch
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
Simple and neat!!!!!! Got an interview and this helps!!!!! Thank you sir!!!!!!
Simple ..wot it is , how it is done ..this is wot we need ..amazing
You make things easy and digestive ... Thank you so much .
Thank you so much it was very helpful. Clear with a good accent.
SQL Server training and interview question:-What is index and how does it make your search faster ?.
Excellent explanation
Thank you, this is a great video! I appreciate the thoroughness and attention to details. Ever consider teaching? Looking forward to more posts!
you were didn't explain clustered and non-clustered differences
Something I was searching for a longgg time! Appreciate your efforts behind the video! Thanks! 🙏
Relly very inspiring sir. Good and go on. You are really an ideal for the future oriented candidates.
Thanks it's really clear
Nice. Your diagram made it easy to follow you. Thanks!
This video got me subscribing without even knowing, lol.
In what scenerio do we use non clustered indexes?
Very clear explanation ...Yu rock....
beautiful and clear explaination
thanks a lot
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.
Nice language sir and topic explain also
Very well explained
perfect explanation about B-tree index
thanks for sharing this video. looking forward to the second part of this video.
Simple and awesome
Great video- summarizing the main points.
Very well explained. Thank you very much.
Thank u so much for making it simple. Is there any video on clustered and non clustered index?
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?
i like way of explanation ..very helpful
Thank you so much for this video :)
thanku
Thank you for this, really helps a lot!
Thanks! Helped me alot to understand!!
thank you so much sir for explanation appreciate you.
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
thank you so much for sharing this vid...you helped me alott!!
Great job! Thanks a million
thank you!!
Excellent sir !
This was a great vid :)
Its a good video but a little short,waiting for Clustered & Non Clustered,How to use & where to use etc..
Really good explanation :)
Sir, Can you explain clustered and non clustered indexes?
As always the best
Thank you. ^^
Clever video, clever man ;)
Nice explanation ..
I assume this structure will be in recursion mode means non leaf node will also have b tree inside.. please confirm
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
Thank you!
Whenever u upload the video how indexes decreases the performance let me know .Nice video
Great Video! Is it possible to adjust the number of non-leaf nodes?
What is difference between
Create table table _name(
And
Create table dbo.Table_name(
Thank you very much, really appreciate!
Nice very nice tutorial
plz add a lecture on dominance index or similarity and dissimilarity index
Will forward your request to the technical team. Thanks for your input.
please let me know how does the data is being divided in root nodes and non leaf nodes.
thanks for the video
Thank you
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.
Thank you, easy to understand
Please explain the Clusterd and Non Clustered index
well done!
Which software are you using
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 ??????????
thanks
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
So easy
even if the search value was 10, a full table scan would be happen because it doesn't know about later 10th values.
How does it work in case of String search?
Thanks now I understand how index is fast, lol other than book index pages blah blah explanation!
I have one question here, how to determine root note? I can see here it is 30. But can you explain why only 30?
What does logical reads means ????
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
OUR LOGICAL READ WAS 146431 BEFORE INDEXING, AFTER INDEXING IT CAME TO 5,,THANKS
Where is the follow-up video of this? Can you please help me with the link?
Sir you please provide video on
WCF
WEB API
Angular 4
SVN
what is version of mssql managemnt studio?
I would like to ask , how index work in background?
What is logical reads?
Awsome!!!!
But you didn't show how sql server creates balance tree?? Please explain
Plz explain cursorcand sequences..
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.
This microphone is pissing me off. Sorry, but I can't get beyond 0:40 into the video...
better
Microsoft Access.
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
no one search by ID because they dont know your ID .
So past
clear and have code examples, very good !
thank you