Cluster index fragementation

Question

Cluster index fragementation

Viewing 5 posts - 16 through 19 (of 19 total)

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

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 1

I just "Love" INT dates and times and the "new" datetime datatypes especially when someone wants to know the duration in decimal hours between a start and end date with dates and times. 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

vkundar Hall of Fame Points: 3431 More actions · Answer 2

Thank you all for your valuable inputs. It was great learning.

I rebuild all the indexes of these tables. could still see fragementaion more then 20 - 25 % for all these tables which was rebuild. We have not done any insert oe update / deleteactivities , why is this so?

Is this something related to filesystem fragmentation?

Cheers,

Got an idea..share it !!

DBA_Vishal

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 3

What is the growth factor for the data file(s)? What is the size of the indexes that are still fragmented?

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

vkundar Hall of Fame Points: 3431 More actions · Answer 4

As this DW environemnt , we have created a BIG FAT datafile of 20 TB. The DB is only 40% full. Autogrowth is none now.

Cheers,

Got an idea..share it !!

DBA_Vishal

SQL Guy 1 SSCoach Points: 15979 More actions · Answer 5

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.