Id like to know how to tell if indexes span multiple files in filegroup
because ive read that some results in dbcc showcontig are not applicable if
the index spans multiple files or so ..Using SQL 2000If you have multiple files in a filegroup then anything you place in that
filegroup (Indexes, tables etc) will span all the files. The Extent
Fragmentation is not applicable but the Logical should be OK.
--
Andrew J. Kelly
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OBYrNoQ8DHA.2416@.TK2MSFTNGP10.phx.gbl...
> Id like to know how to tell if indexes span multiple files in filegroup
> because ive read that some results in dbcc showcontig are not applicable
if
> the index spans multiple files or so ..Using SQL 2000
>
No comments:
Post a Comment