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

Duplicate Object_ID and rows ...etc Expand / Collapse
Author
Message
Posted Tuesday, May 6, 2014 6:05 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 9:06 AM
Points: 124, Visits: 451
Hi friends,
When I run select * from sys.Partitions, output comes out with object_id (with 3-4 same object id no. some time 5-6 for different rows) and the same no. of rows. Does that mean duplicate values got inserted? how to fix this? Please suggest
Post #1567891
Posted Tuesday, May 6, 2014 6:48 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:42 AM
Points: 7,851, Visits: 9,602
There aren't any duplicates here, and nothing that needs fixing.
There is one row for each partition. It contains an object_id which is teh object_id of the table of which this partion is part. So if a table is partitioned into 3 partitions, sys.partitions contains 3 rows which have that table's object id in them - one for each of that table's three partitions.


Tom
Post #1567910
Posted Tuesday, May 6, 2014 10:42 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 1:42 PM
Points: 10,340, Visits: 13,341
Unique values in sys.partitions are defined by object_id, index_id, partition_number. There is at least one row in sys.partitions for each table and index on the table.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1568088
Posted Wednesday, May 7, 2014 8:53 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 9:06 AM
Points: 124, Visits: 451
Thank you much both of you smart guys.
Post #1568514
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse