David has a good list, but I'd also add in that you need a variety of skill levels in the team. There are always sh*t jobs, or boring jobs, and...

If I understand, you have replication running, moving data from 6 separate servers/instances to 1 (or 6) other servers?

Replication typically is fairly low load. Can you explain what isn't working?...

It's not insane. The switch to simple mode does the same thing. If you were able to run the backup with truncate (or no_log), you are still breaking the recovery...

Everything I know about mirroring says that if you go to simple, you have to rebuild the mirror. You can switch to bulk mode, but once you truncate the log,...

Temp tables with one # are visible to your session only.

Those with ## (Create table ##Temp) are visible to all sessions

Typically the client code is in a batch so

declare @id int

insert Table1 select @myval

set @id = scope_identity()

insert table2 select @id, @mynewval

You don't need to Exec() the SQL is you store...

http://www.sqlservercentral.com/articles/Performance+Tuning/monitoringperformance/1007/

I'd concur with Lowell's thoughts. Start a thread with the performance issue, include an exec plan.

For the backup, restore it somewhere to check, but it should be fine.

AND you...

How are you inserting the values? Can you show some code? Typically you don't set values like you did in the trigger as it means you can't handle multiple inserts...

Databases don't access databases. Clients do.

I'm not sure what you mean.

It could help, at the expense of maintaining the view as data changes. Depending on your read v write, this can be a big deal or not a big deal.

You...

Is that all that's returned? Can you show more code?

Have you tried this? I wonder if it will work. Once you go to simple mode, you should be breaking the recovery chain. I am unsure if that will break...

You can search for cross tab queries as well.

I think this is a journalist trying for reads, and getting excited about this "nosql" movement that seems to power the largest web companies out there. However I think he's...