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...

Don't use backup devices. Run each log backup to a new file so you can tell what the transaction size for that period of time (log backup -> log backup)...

Correct, it's cookie based. The forum code doesn't have this as a global setting, but we've passed along to InstantASP as a request.

Correct in that logins really need to be in both databases.

What I'd suggest is that you setup security in the databases separately as needed and then be sure when you...

Those are alarming and you should definitely take action, but I guess it's a strange occurence, perhaps a half transmission of the network conversation and SQL Server isn't sure what's...

Some people have use XML to pass the data into the application. Or you can have the front end send multiple inserts.