PASS. No interest in flying 64 hours to ski for a couple days.

Send me pix, I'm happy to wait for Oct here. I went Oct 25 last year.

The identity is not guarenteed to be unique. You can insert values into the identity column with SET IDENTITY_INSERT ON. They could possibly be duplicates.

Yes, yes, yes, though I'm afraid that will have to wait for a few months. I'll be looking to disappear...

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?