PhilDaniels (5/23/2011)

---

I didn't say you had to be mean or insulting about it. But let's be honest, some people will simply not give what you deserve, even when it is...

giggle snicker ROFLcopter.

Thanks Gail, I had to pass that one along round my local folks...

Andy Warren (5/23/2011)

---

Phil, what would you think if you were on the side of the table and someone applied that kind of "leverage"? It's not to say it doesn't work...

Almost there: select objectid, type, count(*) as cnt from tbl group by objectid, type

Hehe, the worst part of that is where I grew up Bellvue hospital was the local asylum. So my initial thoughts when I saw...

Yeah, I completely misread that for some danged reason. Thank you. I don't understand why it's necessary, the ITP's are supposed to be the TS and...

GilaMonster (5/20/2011)

---

There's no pre-reqs to take the exam, however to get the MCITP certification, you need to hold the MCTS certification.

I wrote my 2008 dev exams out of order, ITP...

No, sorry, crossed my wires. I meant PAGEIOLATCH, sorry. Been one of those mornings......

SQLRNNR (5/20/2011)

---

Craig Farrell (5/20/2011)

---

*claps*, very nice. You're taking the low courses first though? I figured you'd go straight after...

*claps*, very nice. You're taking the low courses first though? I figured you'd go straight after the 450's.

I have no idea why I have to wrap the following in quotes to make it behave... but this is my message.

The other option is to use CROSS APPLY (SELECT...

Just a test, having a problem on another thread, won't let me post reply.

This was only a test. meeeeeeeeeeeeep.

Nils Gustav Stråbø (5/20/2011)

---

But it still depends how the SSIS package is executed. If the T-SQL statement that starts the package "finishes" before package execution is completed, the activation procedure...

Let the queue have only one queue reader. You set it as an option during the create queue command.

PAGELATCH_IO usually. Database growth is a disk wait, but it doesn't trigger it directly, other things would.

You would be better off doing a system review with perfmon counters to...