October 12, 2016 at 1:12 am
Nice QOTD Steve.
Thanks.
October 12, 2016 at 5:31 am
Nice and easy, but I like anything that deals with any internals of indexing. Thanks.
October 12, 2016 at 6:01 am
Good Question, got me two days in a row...
October 12, 2016 at 7:03 am
Thanks for the question.
October 12, 2016 at 7:25 am
Good question Steve. I have to admit I haven't really noticed the index_id column because just a couple columns away is a description that requires no deciphering (type_desc). 😀
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 12, 2016 at 8:55 am
I only remembered this because of some index maintenance scripts that exclude heaps. Thanks for the refresher.
October 12, 2016 at 9:10 am
Good one, Steve. Thanks!
October 25, 2016 at 2:35 am
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply