December 2, 2013 at 10:14 pm
Comments posted to this topic are about the item Filegroup for indexes
December 3, 2013 at 2:50 am
This was removed by the editor as SPAM
December 3, 2013 at 3:35 am
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
found out about undocumented store procedure sp_objectfilegroup as well. Though perhaps that's a bad thing 🙂
---------------------------------------------------------------------
December 3, 2013 at 5:26 am
Good question.
Thank you for the explanation.
December 3, 2013 at 5:47 am
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
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
Nice question.
Thanks
December 3, 2013 at 7:41 am
interesting question..
thanks Carlo.
December 3, 2013 at 10:32 am
Interesting one - took me two coffees. Thanks, Carlo!
December 3, 2013 at 1:30 pm
I took an extra look for me as well. Good question - thanks.
December 3, 2013 at 7:17 pm
Good question. Made me concentrate. Also, had never used the sp_objectfilegroup proc before. Thanks!
December 3, 2013 at 11:00 pm
Nice question..
December 3, 2013 at 11:36 pm
Nice one......
December 4, 2013 at 12:04 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 15 posts - 1 through 15 (of 20 total)
You must be logged in to reply to this topic. Login to reply