|visits||member for||2 years, 7 months|
|seen||Dec 9 '11 at 0:44|
What is the effect on primary keys when moving a CLUSTERED index to a new filegroup?
@Nick Chammas: Mostly general precaution, but I was thinking about how if a table doesn't have an existing clustered index, and then you add a primary key, it creates a clustered index, and I'm concerned that using the create index statement, it's dropping the PK because of this. Then of course, when it recreates it on the new filegroup, it does it as a regular index or something, and possibly killing any relational dependancies.
|asked||What is the effect on primary keys when moving a CLUSTERED index to a new filegroup?|