RE: how to Create index online?

SSC Guru

Points: 1003863

March 29, 2014 at 8:33 am

There are other caveates that will prevent an index from being bilt/rebuilt in an online fashion unless you have 2k14. If the table has blobs in them, then the clustered index cannot be built or rebuilt in an online fashion and the non-clustered indexes cannot be created or rebuilt if the index contains a blob in the INCLUDE clause.

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