Bert, another interesting topic, so when creating an index do you start by querying the table for row counts on columns that you are considering to place in the index? Maybe in another video you can explain a little deeper. Thank you for all the interesting topics. Look forward every Tuesday to see your next subject matter.
Found your channel just now and it looks neat. I find it somewhat difficult to find concise content and well organized about database out there. Looking forward for your content. 👍🏻👍🏻👍🏻
Good info. So please clarify, is high cardinality the same thing as low density? Watching Itzik Ben-Gan's Cross Apply videos I'm assuming low density = large number of unique values = high cardinality (like customers in an orders table). And high density = small number of unique values = low cardinality (like shippers in an orders table)?
I was desperately hoping the cardinal would know nothing about cardinallity and leave
I must say, I was kinda skeptical but this really helped me get a quick overview of Cardinality. Thank you!!!
Bert, another interesting topic, so when creating an index do you start by querying the table for row counts on columns that you are considering to place in the index? Maybe in another video you can explain a little deeper. Thank you for all the interesting topics. Look forward every Tuesday to see your next subject matter.
Found your channel just now and it looks neat. I find it somewhat difficult to find concise content and well organized about database out there. Looking forward for your content. 👍🏻👍🏻👍🏻
Doesn't this contradict the other video "Does The Order Of Index Columns Matter? " info
This deserves more love!
Will you make a normalisation video till the last degree
Good info. So please clarify, is high cardinality the same thing as low density? Watching Itzik Ben-Gan's Cross Apply videos I'm assuming low density = large number of unique values = high cardinality (like customers in an orders table). And high density = small number of unique values = low cardinality (like shippers in an orders table)?
Check out this article: blogs.msdn.microsoft.com/bartd/2011/01/25/query-tuning-fundamentals-density-predicates-selectivity-and-cardinality/
This is excellent!
Awesome video :)
cool. Love you, Man! :)))
have a like before i finish the video
Oaf, I liked your other videos I've seen so far, but I could do without the cartoon cardinals and cheese lol. Still good info
amazing 😂😂😂