Which error? The unable to open error?

We definitely won't allow responses without logging in, but viewing the thread might make some sense.

Membership is at the top of the front pages. Changes constantly, about 1,000 a day or so.

I guess most people don't use it, but the replies seem to underscore my point. Most people posting haven't given a specific area where it has or hasn't worked. It...

The SP3 message slipped in there and this has been queued for awhile. It's been edited a few times since I wasn't really sure how to phrase things. SP3 is...

Service Pack 3 is coming. It's slated for late this year, as soon as they get 2008 to RTM, lots of resources should move to test this patch.

mediasets, mediafamilies, etc. aren't used a log. I'd save backupdevices aren't used, but some people apparently like them. I always back up to disk.

You can pick the "See More" on the front page, with the scores as well to see the top xx on there. Not sure we have a list of who's...

Snapshot is essentially a backup. If you are already doing this, and copying to another server (and you should), grab it from there. This would allow multiple restores the same...

It's definitely personal preference, which is why I wanted to point that out with this book. I like case studies and walking through samples more than abstract code with step...

In a new or old table, the rows are not in order. There is no guarantee without an ORDER BY clause. I could alter the clustered index, not the data...

Primary reason to not do it? DR

If you have stored procedures in one place and data in another you have two separate systems to get back running if there's a...

If you can, memory is a great first step. Often it solves problems quickly. CPU might be next, or splitting out the data across disks. You'd have to look at...

Correct, you don't subquery inside the CASE.

However, if you have NULLs, then you can IFNULL( field, default value)

tempdb gets reused. If it's getting bigger and bigger either you have open transactions that won't clear (dbcc opentran) or the load is growing.

I never restart services unless we patch...