6 reputation
1
bio website
location
age
visits member for 2 years, 9 months
seen Dec 9 '11 at 0:44

Sep
12
awarded  Student
Dec
8
comment 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.
Dec
8
asked What is the effect on primary keys when moving a CLUSTERED index to a new filegroup?