Fill Factor

Question

Fill Factor

Viewing 3 posts - 16 through 17 (of 17 total)

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

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

Just to add to this because it recently came up on another thread... an even more important subject is that of maintaining statistics.

--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)

Arsh SSCertifiable Points: 6354 More actions · Answer 2

GilaMonster - Saturday, November 11, 2017 10:52 AM
The clustered index is the table. Once you have a clustered index you don't have a separate, underlying table.
And a new row has to be inserted into index pages because all nonclustered indexes MUST be consistent with the underlying table. Hence a row gets inserted into the table (heap or clustered index) and then into all of the nonclustered indexes before the insert is considered complete.

Thanks Gail. You hit the nail. I was missing that understanding.

Arsh SSCertifiable Points: 6354 More actions · Answer 3

Thanks Jeff , John, Jason , Grant and Gail for the useful insights.