Is my Create Index Online finished?

Question

Is my Create Index Online finished?

Jon.Morisi

SSChampion

Points: 12846
More actions
February 27, 2013 at 8:35 pm

#271014

If I create an INDEX like the following
CREATE NONCLUSTERED INDEX [IX_table_col1_col2] ON [dbo].
(
[col1] ASC,
[col2] ASC
)
WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = ON) ON [PRIMARY]
How do I check up on it to see when it's 100% completed

Viewing 3 posts - 1 through 2 (of 2 total)

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

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

Jon.Morisi (2/27/2013)
If I create an INDEX like the following
CREATE NONCLUSTERED INDEX [IX_table_col1_col2] ON [dbo].
(
[col1] ASC,
[col2] ASC
)
WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = ON) ON [PRIMARY]
How do I check up on it to see when it's 100% completed

You'll get the following message when it's completed if you're running this from SSMS... just like any other query.

Command(s) completed successfully.

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

Jon.Morisi SSChampion Points: 12846 More actions · Answer 2

Oh, well... I guess it was just too fast for me to believe 🙂