OK, thanks for the advice, matt.

Matt Miller (3/15/2008)

---

I am not willing to shell out money to get my hands on the actual SQL standard from ANSI, but considering some of the dreck that's been coming...

Jeff Moden (3/15/2008)

---

Compare that to where C/C++ programmers have been for over 15 years: they can write new code targeted to run on multiple different platforms right from the start...

Great!

Thanks,

Either way works for me. I am just tired of trying to read 40 lines of SQL code formatted as Arial. I have to keep cut-and-pasting it over...

This doesn't work on Sql2000 does it?

I seem to recall that the "hooks" were in Sql2000, but they never returned anything. Maybe there is some patch or tool that...

Check your dependencies; see if any of them are failing to come up on the primary node. For instance, if a disk volume that SQL is dependent on cannot...

isn't sqlio.exe a benchmark test tool, not a monitoring tool?

Use perfmon and look at the idle% and disk queues on your physical disks.

Where can I find this function documented? I cannot find it in my SLQ2005 BOL.

Does anyone check these things?

It is really disturbing how many wrong answers there are. It also makes me wonder how the folks with over 90% right ar doing it...

This answer given is incorrect.

This is reflected by the fact that the Microsoft article no longer says what the answer quotes it as saying.

Drexel is in Philadelphia, PA and these are mostly IT/IS majors (part of the Business Administration school).

Jeff Moden (3/15/2008)

---

Dang, Barry... good stuff but awfully long for saying that folks preach the standards right up to the point where the standards don't work for them and then...

Huh, it works just fine for me.

Are you sure the is SQL Server 2005? Is the database possibly in compatibility mode=80?