I agree with Scott on the function thing. I'd use a function as it would work well and I'd put the time zones in a table. You can use UTC...

check the filesystem or tape logs as well.

I'm not 100% sure, but I guess all DML statements are checked against triggers to see if they match. However the check doesn't create any load. If it does on...

Since you're working cross platform, I'd recommend calling Microsoft PSS and having them work with you.

Are there any other errors that are occurring? Is it always in the same types...

Very strange. HAve you run DBCCs on them? Any issues accessing them once they are open?

If you try to access one before it's started, does it work?

I'd suggest some logging as well. Create a table to store IDs or PKs or just varchar data, then insert data at various points in the table to determine what...

The new KB article is for 2000 and I should have called that out, though I think it's still a bad programming problem.

I agree with Ed that regular SPs would...

I think SQL Server developers have more jobs because there are typically more of them than DBAs. However BI/warehousing is a place where I am seeing more growth.

I've heard Vista is "usable" with 1GB. Luckily I've got 2GB sitting around

It's not easy, but I think we have great rewards. Talk to doctors and lawyers. They worked 100+ hour weeks in school! And they get to dress up, work insane...

I tend to agree with Colin on the v2005 and 64bit if you can swing it. Even if your box only support 4GB or 8GB, if you're on 64-bit, then...

colin has the best advice I've seen. Usually things aren't quite the same when there's a restore. I'd definitely rebuild indexes to defragment things and be sure you get the...

Most of these tip lists are from Brad Magehee, who is the editor of sql-server-performance.com.

I'm not sure how much of a performance problem there is, and given their benefits...

If the FBI starts watching me, they're in for a long boring ride.

Waste is an issue and I don't have a solution. My kids wonder why we don't send it...

No, but I'd be interested as well.