The server was rebooted last night, so perhaps something broke.

I flipped the TZ to GMT and back to MST. Have someone looking at the server itself to see if...

If it's the distribution database, then you have subscribers that have not gotten their subscriptions, so the data cannot be removed. Be sure all subscribers configured have gotten their data.

This sounds like homework. Also, please don't use all caps.

If you show some effort here, we can try to help.

You don't save in licensing unless you have Enterprise edition. If you have 2 standard instances, you license them separately.

You might want to separate out tempdb usage, perhaps with two...

It's not the people!

Mostly it's the time (time in air, time in airports, time difference) that's messing me up and making me cranky and miserable. Also, since that's the place...

We store all images in the db here, the ones in articled, edtiorial, etc. Hasn't been an issue so far.

If they're not too large, it should be ok. The queries...

Look up charindex in Books Online

Use your normal sum, but add a having(sum()) >= xxx and order by date.

I played a lot in middle school /high school, even on some early computer games that were similar. I really enjoyed the game and he will be missed.

Thoughts and prayers...

Interesting to hear. Do you have some comparisons of loads between the systems? Interested in writing up something on your experiences moving to 64-bit?

You'll need to test and see if IIS or SQL needs more resources. You might be able to shade your usage one way or the other, but I'd be tempted...

Build the table, and determine what the query needs to return. You can index on key fields to return things quickly in an index seek, though you need hardware to...

After "upgrading" (not upgradation) 🙂

The upgrade doesn't move these since you might need them in 80 mode. If you want to change to 90, then just change the option for...

I assume other backups work (for user databases)?

I'm not sure what you can do other than rebuild msdb from scratch. Or restore from a previous backup.

I'd script out jobs, alerts,...

The service account for SQL Server needs rights, not your account.