Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Partition on table with no data and table with data Expand / Collapse
Author
Message
Posted Tuesday, August 13, 2013 4:34 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 7:57 AM
Points: 14, Visits: 33
Hi,

I have a table created and as of now there is no data in the table, I created a partition view on this table based on the paiddate field. Then I have loaded nearly 3months of data in the same table where partition was created. then I checked the sys.partitions for the same object, but the rows in sys.partitions is not matching with the no of rows in my data for the paiddate.

How can I check my partition is working correctly or I can drop the partition function and recreate it again. Please advise

Regards
Kalyani
Post #1483638
Posted Tuesday, August 13, 2013 4:10 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 1:24 PM
Points: 805, Visits: 722
Do you have a paritioned table or a partitioned view? Can you post the scripts for what you have, so that we can understand what you are talking about?

Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1484022
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse