Piling on a bit, I agree. You just need to do fundamental data collection of the performance metrics. Use perfmon or, if you have a little money, you might pick...

Once you know the CPU is high, I'd start drilling down on what's causing it to be that high. What processes are using it up? I'd go to the DMO...

This is one of those places where the Microsoft documentation, best practices and advice is the best place to go for information. They really do lay out the choices correctly....

Before you put different applications within a single database, I'd check to see just how much cross-dependencies there are between the apps. Do they share tables & procedures? If so,...

It's pretty likely you're using one of the non-deterministic calls within the function. Check here to validate that.

You shouldn't be getting divide by zero errors when estimating the size of a row. If you are it's down in the estimating how much data per page calculations, which...

If you're just trying to execute the create statements as a batch, SQLCMD is the tool.

You could, with only a little bit more work, take advantage of PowerShell for...

But understand, you're holding open the transaction, locking resources, possibly blocking other users while that wait is in place. It could be a very dangerous thing to do.

What exactly is...

You can also get into more arcane, and expensive, approaches that will solve the problem. Are you on a SAN? Most SAN systems these days can do a transactionally aware...

ALZDBA (12/20/2010)

---

just my 2ct.

With regards to a log shipped db, connections will have to be modified at switch time !

With regards to a mirrored db solution, you prepare all...

Elliott Whitlow (12/20/2010)

---

Well Grant can correct me if he feels it necessary, but there are very few cases where I would want to setup mirroring, I'm really hesitant about the...

Gianluca Sartori (12/20/2010)

---

Yes, that's my post!

I couldn't load Grant's blog today, it seemed to be down, but now it loads and also I got a mail from him.

I can't believe...

So you want move the data between servers without downtime? That's harder than a simple backup & restore.

While you can backup your database in 32bit and restore it in 64bit,...

Check the execution plans on both queries. I'm pretty sure you'll see that they're different. You're hitting a bad parameter sniffing problem. I'd also suggest trying the query within a...

Paul White NZ (12/16/2010)

---

I just typed this successfully in 2008 SSMS with Intellisense on (which it always is):

SELECT ...