Please take the language and the random insults elsewhere, they have no place on a professional forum.

Phantoms are indeed possible under read committed snapshot,...

The full backup contains the complete state of the database at the time of backup, it's not a...

Looks like all errors were fixed. Now sort out your backup strategy.

Err... think about whether the first option is even feasible. Imagine a 2TB database with 100 transactions/sec....

http://msdn.microsoft.com/en-us/library/ms345124%28v=sql.90%29.aspx

MCM (or what it's being converted...

http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ Chapter 4

Perfectly normal. SQL will use as much memory as it can, up to the configured max server memory. If SQL's using too much memory, drop max server memory slightly.

Rum a load test of your app, see how large TempDB gets. Set default size to slightly larger.

If you came to me with that on...

Buggy network driver, something broken somewhere on the network or a hack attempt.

I've seen a few articles on that SQL site like that,...

May I suggest normalising the tables? As long as there are comma-delimited keys that's going to be hell to write queries against and will likely have horrid performance problems.

I'd suggest doing that in application code, not database code. They're more designed for that kind of work.

That is going to be incredibly inefficient. What are you trying to do there?