Dear Kendra. I believe that you forgot to mention one important thing that statistics (that SQL server creates during index creation) consists information about the first indexed column only. That is why columns order in index is also important
Василь Павук you are thinking of the histogram in the statistics, perhaps? The density vector portion of statistics for multi column indexes does describe more than the first column. And SQL Server can also bring in info from other column statistics if it wants to. I don't think we'll get too deep into stats internals in the next episode but I'll see where the demo takes me 😀
Thank you , your videos are very helpful
Dear Kendra.
I believe that you forgot to mention one important thing that statistics (that SQL server creates during index creation) consists information about the first indexed column only. That is why columns order in index is also important
Василь Павук you are thinking of the histogram in the statistics, perhaps? The density vector portion of statistics for multi column indexes does describe more than the first column. And SQL Server can also bring in info from other column statistics if it wants to. I don't think we'll get too deep into stats internals in the next episode but I'll see where the demo takes me 😀
Also Resumable Index Rebuilds are coming very soon. :-)
Do you consider creating a playlist for "Dear SQL DBA" series?
I have one all set up, it's here: ua-cam.com/play/PLoM-GGCV9ZrIgOR5DQ-7eF79_E9ABRVg6.html
Dear Kendra as you mention Source Code / Source Control do you know of any good tool that interacts with your SQL server instances?