Hello all Experts,
I have a question regarding the index size:
i saparate 2 file group for my database, one is the primary the second one is for index ( i am not
sure what is good or bad about doing this) the innitial though was to just keeping it saparate i guess) -
so , every time i create an index , i create it on the filegroup that i create saparate for the indexes as the syntax below
CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name
[ ON | filegroup_name ---- this is where i replace the filegroup using my index file group]
now this file group seem to be getting too big (3 times bigger than my primary file group.
what should i do to reduce the size and how....