A few questions:

1) How many CPUs is each box licensed for? I'm w.a.g.ging here, but I'm wondering if you're not seeing all CPUs because the license isn't set up correctly.

2)...

Did he feed them after midnight or get water on them?

SET Snark = OFF;

L' Eomot Inversé (11/14/2011)

---

Brandie Tarvin (11/14/2011)

---

Especially when DBAs are forced to use vendor databases over which they have little schema control. Don't beat up the people who have to deal...

WOW...

...just... WOW.

EDIT: In regards to all the MERGE connect bug issues, that is.

After looking at the link Remi posted, and noticing the MERGE answer there, I have to wonder. For a simple one or two table update like that, is MERGE really...

Thanks for your input, Gail. I appreciate it.

Depends on the database, the environment, and the DBA / Dev, Tom.

If you don't ever do anything with partitioning, and don't have a database big enough for that sort...

GilaMonster (11/14/2011)

---

Likewise and a waste of time when typing in...

raotor (11/11/2011)

---

Brandie Tarvin (11/11/2011)

---

The transaction will continue to run until it's completely rolled back. Rollbacks can take a while, just like the initial execution. It depends on how far the...

Brandie Tarvin (11/11/2011)

---

That's my plan for this afternoon is to get signed up...

That's my plan for this afternoon is to get signed up and catch...

Ah. I made a couple of different errors on the above code (non-syntax). I'll post a corrected version up later for anyone wanting to use it.

EDIT:

Corrected code that prints the...

What GSquared said.

FYI: Depending on the business, you could get fired for uploading a database onto the internet. Engage in CYA. Post sample tables and sample data insert scripts...

GAH!

Thank you, guys. I knew it was something simple.

EDIT: I was also looking at the wrong bit of code in my error search.. DOH.

Given the scenario, this sounds like a homework question.