ONLINE=ON means that users will be able to access your table while is being rebuilt.

With OFF this table will be locked for entire duration.

Even if would be really the case, SQL Server would leave...

This is what this script is doing:

1. Drops PK (which is non-clustered).

2. Recretaes PK, non-clustered again.

3. Creates clustered index on PS.

4. Drops it.

My questions:

1. Why do you need to touch...

If we are talking about partitioned table, then clustered index is needed. If you create non-clustered index on PS, then...

Was your instance restarted recently?

Was it started from DOS-prompt with -x argument?

1. Create partition function. List all these dates as boundary values in this function

2. Optional. If you plan to place partitions on dedicated files/filegroups, create them. Number of FG =...

You can create articles on these 6 tables.

Congratulations! You have no missing indexes !

But if seriously, do you have "view server state" or higher permissions?

Thanks for recommendations Jack, but I have couiple of questions:

1. How I can disable sa account? There is no such menu item in SSMS. Or should I do: ALTER LOGIN...

But you have a declaration of @sqlstatement:

DECLARE @SQLSTATEMENT VARCHAR(2000)

First, it is not completely clear what you mean "move data".

Is it one-time move of entire database(s) from one...

What version are you using ?

If >= 2005 then use alter index ... with (online = on)

As for your question, yes it may take around 35 min to undo.

Did you have a chance to run DBCC updateusage ('db','table') ?

Also try this:

DBCC UPDATEUSAGE ('your_database_name','dead_lock_info')

Run this:

DBCC CHECKTABLE('dead_lock_info')