You're welcome.

Actually, one (and only...

If you look at the data on failover clustering in Books Online/MSDN, you'll note that there is a long list of requirements. For one, the disk drives have to...

When you say "it doesn't work", do you mean you get an error message, or you get zero rows of data, or something else?

The second solution, the one from the PM, is a triangular join.

Ran it on the same table and data that I just ran my solution on: 172 milliseconds...

No, that's not a triangular join. It's a linear join. No RBAR in it.

I just tested it on a copy of your table with an index on DateValue,...

The first thing I would do is break the proc up into smaller procs and a master proc that calls each smaller proc in sequence. That will make the...

Text data type stores in an odd way. I don't think it shrinks once it's been allocated.

Edit: varchar(max) works much better, but you can't use that in compat(80).

I don't think there's a standard reference.

What I've seen, when I've seen it, has been:

int

tint

sint

bint

dtm

sdtm

vc

nvc

char

nchar

dec

num

flt

I don't use these, but they're what I've seen someone else use.

In my prior job, I was on hourly, and if I had to answer a work-related call or e-mail, it went on the clock. I just had to e-mail...

Very interesting question, but mainly because I never realized that SQL 2008 had "colletors" in it.

In case anyone is wondering, a "colletor" is: "a multicellular trichome of a leaf or...

Check your log files in a log parser (ApexSQL has one of those, so does Lumigent). The shrink file command should be in there, and it will have data...

They're stored as hex. You could build a converter to convert to binary, but there isn't one in SQL that I know of.

For tables that often need to be queried on time, without date, I've found that calculated columns (generally with an index on them) is a great solution. Keep the...

You're welcome.