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