A third party tool will allow you to generate the reversing entry if you still have the logs from a few days ago.

The problem is that other things outside the...

The problem is that you need to know the total # of columns to get the CASE to work properly. Or you have to cover all bases, like

select

CASE hour

WHEN...

Without seeing the code it's hard to know what is causing the delays. If there's lots of data, especially not indexed, it could be slow.

I'm not sure I'd do a...

I think Lowell has given some great suggestions. I use ORDER BY NEWID() for randomization as well when we do contests here.

It's definitely an AD security error. Google for it and you should find a couple solutions that hopefully will match up with yours.

How many services are running on the server. Are there really 4 instances? I'd be sure there isn't something mucked up on the server as well.

Good luck Anthony in making a change. If it's a bad place, then I'd recommend leaving.

I'd caution you though that the grass isn't always greener at the next company. Move...

Good point on the Excel code.

Every product has bugs and I'd consider this one just as I'd consider Excel's driver not sending over more than 255 character.

What processes are using logs of memory?

30MB isn't necessarily a lot of memory

Good points there, but I guess I'd like to hear more about why this is a bad move or where it makes sense and where it doesn't. If you're driving...

I don't think it was Bert, but thanks to him for pointing this out as a potential problem.

Whoopsie! It's corrected and I guess the spell checker only does so much

http://www.sqlservercentral.com/columnists/bknight/spattachdb.asp

Not sure. There's always half.com.

I get a scheduled maintenance page at halfpricecomputerbooks.com

Windows will always have a lot of processes running. Most of them take very little CPU, so I'm not sure what the problem is. If you run Task Manager and...