Maybe this will show you what is actually happening:

If object_id('tempdb..#TestReplace') Is Not Null

Begin;

Drop Table #TestReplace;

End;

Select...

Yeah, that is what I figured was going to happen. For the short term, I...

For anybody who is interested, setting MAXDOP to 1 allowed the process to complete successfully, even with ONLINE=ON.

So, it definitely looks like an issue with parallelism on this index. ...

By unrecoverable, I mean...

Thanks - that is what I was afraid of. I guess we are going to open a ticket with Microsoft.

Well, I guess the answer is: It depends :hehe:

Do you want to slow down your inserts/deletes? If so, then yeah - you probably want to add some indexes. ...

No, you are not going to be able to do that. What you will need to do is build the cluster, install SQL Server on the cluster and then...

Everything looks right - don't see anything that jumps out and says there might be a problem with the cluster setup.

Sorry, I can't think of anything else to look at.

You can use sp_notify_operator:

sp_notify_operator

[ @profile_name = ] 'profilename' ,

[ @id = ] id ,

[ @name = ] 'name'...

Okay - that makes sense. I did not see the other replies before I sent mine. I agree with Steve, you really should be looking at setting up...

Why are you remoting into the server to run these queries? You should use SSMS on your local workstation instead.

I would be very concerned about moving temp files used...

The semi-colon is a statement terminator, so you wouldn't put it at the end of every line. Only at the end of each statement - and only before the...

Garadin (12/12/2008)

---

Roger that. Just made the change. Mine was set to 8. It always kinda bugged me that it was so big, but never really bugged me...

Christopher Stobbs (12/11/2008)

---

Thanks for the alternative Jeff 🙂

but I must say sorry I don't know how the hanging ) stayed as it did.

...

Well, to be perfectly honest I am now at a complete loss. You really should be able to see that database being started by SQL Server. It really...