Bhuvnesh (11/15/2012)
Dave-644455 (11/14/2012)
However partitioning on this Identity column wouldn't be very useful.Why you think that partitioning wouldnt be useful here ? i think it will help you here as you are handling high volume of data
Why would you want to partition data on an Identity column best practice for partitioning is to ensure like data is grouped together, eg Time sliced data, divisional groupings, or something similar.
_________________________________________________________________________
SSC Guide to Posting and Best Practices