Post reply

Partition on table with no data and table with data

  • August 13, 2013 at 4:34 am

    #276874

    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

  • August 13, 2013 at 4:10 pm

    #1641181

    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?

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply