Posted by Dr Warehouse on 11/30/05 13:18

Hi Stu,

Thanks. Nonclustered indexes are already on seperate filegroups. Do you
know wat the difference in locking / performance gain is if the table
structure stays on the 'old' filegroup (in case of an clustered index
to a new filegroup) or the table structure is on the new filegroup.

Danny

• Next in forum: Re: Wildcards On Columns?
• Prev in forum: Re: Clustered versus Create table on high speed FILEGROUP
• Thread view: Re: Clustered versus Create table on high speed FILEGROUP

[Reply to this message]