about partition?

I created partition for one table

How to check if the partitioned data is correct?

Also if there is easier and quick method to tune this partition?

any idea? many thanks

A first ideea is to use $partition function (in Books Online have an example); with it you can get the number of rows in each nonempty partition of a partitioned table or index; make a job that insert time to time this data into a table and read it periodically.

Gigi Ciubuc
www.sqlserver.ro|||

thank you

I am going to read BOL