Post reply

Filegroup for indexes

  • December 2, 2013 at 10:14 pm

    #283051

    Comments posted to this topic are about the item Filegroup for indexes

  • December 3, 2013 at 3:35 am

    #1670327

    Very interesting one. Thank you for the post, Carlo. 🙂

    (even though having some knowledge on this, I actually never noticed the table changes its FG)

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • December 3, 2013 at 3:43 am

    #1670328

    found out about undocumented store procedure sp_objectfilegroup as well. Though perhaps that's a bad thing 🙂

    ---------------------------------------------------------------------

  • December 3, 2013 at 5:26 am

    #1670346

    Good question.

    Thank you for the explanation.

  • December 3, 2013 at 5:47 am

    #1670354

    According to the explanation - I think that 3rd query shall be about table, not about index:

    WHERE i.name = 'Tab1'

  • December 3, 2013 at 6:30 am

    #1670365

    Pawel Borkowski (12/3/2013)

    According to the explanation - I think that 3rd query shall be about table, not about index:

    WHERE i.name = 'Tab1'

    No, it returns the filegroup for the index.

  • December 3, 2013 at 7:24 am

    #1670388

    Nice question.

    Thanks

  • December 3, 2013 at 7:41 am

    #1670394

    interesting question..

    thanks Carlo.

  • December 3, 2013 at 10:32 am

    #1670464

    Interesting one - took me two coffees. Thanks, Carlo!

  • December 3, 2013 at 1:30 pm

    #1670525

    I took an extra look for me as well. Good question - thanks.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • December 3, 2013 at 7:17 pm

    #1670577

    Good question. Made me concentrate. Also, had never used the sp_objectfilegroup proc before. Thanks!

  • December 3, 2013 at 11:00 pm

    #1670587

    Nice question..

  • December 3, 2013 at 11:36 pm

    #1670594

    Nice one......

  • December 4, 2013 at 12:04 am

    #1670607

    Nice question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 4, 2013 at 10:49 am

    #1670797

    Definitely a good question.

    At first I thought is was easy. Then I thought maybe it wasn't - could it be possible that in the case of a clustered index the leaf nodes didn't go where the index was told to go? And then I though that was a crazy idea. And then I vacillated beyween the two possibilities - and ended up trying to look the answer up - but I must have been having a mind block about search terms :doze: because neither MSDN's built in bing nor google turned anything useful up. So I went to bed, and the next day I went with my original thought, picked the easy answer, and got the point - and then discovered from the explanation that it's nicely documented in MSDN on precisely the BOL page that I ought to have looked at first :blush:. And it can't have been jet lag - yesterday I had only had a 4½ hour flight with no time zone change.

    Tom

Viewing 15 posts - 1 through 15 (of 20 total)

You must be logged in to reply to this topic. Login to reply