December 1, 2004 at 5:52 pm
I am moving a rather large database to new servers. We will have raid arrays that are dedicated to certain functions. Tempdb on one, indexes on another, data and log separated on yet two more arrays. It will be so nice...
My question is in regards to the filegroup that i am creating for the indexes. I have scripted all the indexes out, and have tested loading them into a new filegroup. But I did not include the primary keys that are clustered. Shoud I?
The majority are simple indexes. There are a couple Clustered indexes and unique clustered indexes. But no Primary keys...
Whatcha think?
December 2, 2004 at 7:04 am
You can't have any clustered index on a different filegroup than your table, primary key or not.
December 2, 2004 at 11:40 am
why is that?
December 3, 2004 at 1:05 am
The lowest level of the clustered indexes in SQL Server are the data pages, so if you move the clustered index, you are in fact moving the data.
Ian Dundas
Senior IT Analyst - Database
Manitoba Public Insurance Corp.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply