Create the new instance, copy & attach all the databases, drop the old instance.

It is a pain in the tucas.

SQL Server is not simply a file on a machine...

It's just how clustering works. The clustering service shares the disk storage and expects to find the databases there when a failover occurs.

Active or passive, how many instances of SQL Server do you have? That's how many tempdb's you'll have.

And they can't go onto local system drives (least not that I've ever...

I still don't think you're providing quite enough information to make the determination, but here's a SWAG based on what you've provided:

SELECT DATEDIFF(mi,t1.[END_DATE],t2.[END_DATE]) AS MinutesDifferent

,t1.[OPERATOR]

FROM dbo. t1

CROSS APPLY (SELECT...

So I'm ineligible...

I like this site for a number of reasons. First off, the articles are informative, but more than that, because of the structure that you guys set up,...

I'd also look at the order of processing between the two procedures that are deadlocking. Be sure that if Proc1 is accessing the tables in the order, A, B, C,...

Damn, I didn't even get all the tape wrapped around my fists to start swinging.

Good choice. I'm facing a major redisign on a fairly substantial system to remove the uber-code...

Sure sounds like you have a foreign key constrain violation. Check the data incoming against the data in the table that the error indicates. You have to have a discrepancy...

If I'm reading it correctly, that last image is the new newsletter? I kind of liked having the little tease sentence of what each article is about. It gave me...

One more endorsement for Solid Quality Learning. We've had Itzik Ben Gan teach his course where we work four times and he's on his way in for a fifth. It...

Excellent. I'll get it plugged in as soon as I can.

That's excellent. I've really enjoyed using your program and I missed it terribly when I spent time (more & more lately) in DBPro.

For what it's worth, I'm still using RedGate's...

Hey,

I see you found the the thread over on RedGate. It is disapointing that the RedGate tools don't work with DBPro, yet. From the MSDN Forums for DBPro, I get...

I tried maintaining a professional blog but I found I didn't have something to say often enough to make it worth it. Instead, when I've got something I really want...