Thanks for the explanation .

Does below variable data type consider BOL data type in sql 2005 ? Will this column data transfered to the new filegroup when running create unique...

I just check on my MSSQL table and found out the cluster index is build with multiple column .

UNIQUE CLUSTERED INDEX [fileidx1] ON [dbo].[FileList]

[Account] ASC,

[PathId] ASC,

[FileName] ASC,

[FileNameLength] ASC,

[Tdate] ASC

ON...

rows5303873667

reserved 971,053,408 KB

data_size 960,138,384 KB

index_size 10,818,096 KB

Does DBCC DBREINDEX (dbo.YourTableName, PK_YourTableName ) similar to CREATE UNIQUE CLUSTERED INDEX PK_YourTableName ON dbo.YourTableName(YourPKFields) WITH (DROP_EXISTING = ON) ON [NewFilegroup]...

The table have only one index which is a cluster index.

So, if i reindex these table using DBCC DBREINDEX, Is the size of the index equal the size of...

the reason to create this policy is to ensure the sql service account is not the local admin group members.

I do some research and found WMi can use to retrieve...