There is nothing in the error log about startup? Have you checked the disk for problems?

Thanks for the comments and they are interesting. I think the fact that just about everyone is a technologist is key. Can you imagine this if you had lots of...

http://www.databasedaily.com, another site run by this one.

Thanks for the followup and good luck with the unit.

Steve

How big a DB? Is this just reporting services? Are these complicated queries? Hard to recommend hardware. Can you estimate based on existing OLTP hardware?

At a min, I'd go 2CPU,...

Tape is fine and most people still use it. It's one of the cheapest ways to get a backup offsite (you do take backups offsite, right?)

I've had this same issue,...

I do test some things on the test database, however copying the query over and running it on the production database would still have caused the issue. It wasn't that...

Thanks and I am glad. That one wouldn't have been quite as fun to fix

How about you send me the quarter and I flip it?

There is definitely discrimination against those without degrees. However, I don't toss resumes and I ask HR not to if there is significant experience. To me, the interview is still...

RedGate Software also sells an inexpensive tool to help do this. Their Data Compare product.

We'll think about it. That response was put in there to recycle posts and see if they'd get an answer the second time around. Some forums go get a bunch...

But more or less columns?

select max(mydate)

from (

select max(lastdatea) 'mydate'

from MyTable

union

select max(lastdateb) 'mydate'

from...

You can run profiler to capture usage, analyze, etc. PIA if you ask me. The best and easiest way is to deny login for those you're not sure about and...

, tomorrow.