Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 partition table

Author  Topic 

noamg
Posting Yak Master

215 Posts

Posted - 2009-09-27 : 02:52:35
hi,
I have a partitioned table. when every month i add a new partition + filegroup + file.

how I can check where the rows are physicaly located ?
thanks

Noam Graizer

cat_jesus
Aged Yak Warrior

547 Posts

Posted - 2009-10-01 : 13:24:19
See $PARTITION in BOL

An infinite universe is the ultimate cartesian product.
Go to Top of Page
   

- Advertisement -