Home Forums SQL Server 2012 SQL 2012 - General Cluster index fragementation RE: Cluster index fragementation
SQL Guy 1
SSCoach
Points: 15817
More actions
June 5, 2014 at 2:35 pm
#1719456
DM_CV_AGGR_FACT_POLICY_COVERAGE_ID] [int] IDENTITY(1,1) NOT NULL -- is ever increasing.
But place it on the 1 st place in your clustered index. It still can be partitioned by BIZ_MONTHYEAR even if it is on the 2 nd place.