Posted by Erland Sommarskog on 09/28/07 21:05

traceable1 (thhamlin@gmail.com) writes:
> Thank you so much!
> i have the query:
>
> select *
> from sys.data_spaces ds,
> sys.allocation_units au,
> sys.partitions p,
> sysindexes si
> WHERE
> si.name = @indname
> AND si.id = p.object_id
> AND si.indid = p.index_id
> AND p.hobt_id = au.container_id
> AND au.data_space_id = ds.data_space_id
>
>
> If this comes up with nothing, it is not a partitioned index.
> If it is a partitioned index, i can get the file group names from this
> and only optimize the PRIMARY and 2007 partitions.

Great to hear that you sorted it out, and thanks for posting your
query!



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]