October 31, 2006 at 8:16 am
Does anyone know how to, during SS 2005 installation, to indicate that the indexes should be put on a different fixed drive than the data. I am hoping to do this to improve performance.
October 31, 2006 at 7:41 pm
My expectation would be that you do this when creating the individual database rather than the SQL Server installation.
When you create the database, you will need to create multiple filegroups, then when you create the indexes and tables, you can specify the filegroup you want to create that object in.
I suggest that you lookup filegroups in BOL for a more definitive description.
November 2, 2006 at 4:01 am
that's one of the things they did not alter for sql2005.
You still have to mention the filegroup for each index and there is no setable default (other then the normal table-default-filegroup).
Keep in mind when it comes to indexes, they need to be backuped in combination with their corresponding tables !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply