First you should use @@scope_identity for the value.

A trigger will get this if you need it always done. If not, moving to GUIDs allows you to generate things in advance.

Are they not separate steps in the job?

:), the Prius update is next month. Alternate energy and cars each month. 520miles on the last tank, trying to beat that with this one, around 52mpg with my son...

Good comments and it's definitely a balance. I've heard issues about our grid, which I do think are legitimate. The idea of storing power in a movable form, perhaps fuel...

Being stupid can help: http://www.darwinawards.com/

:), passed along.

OK, the author (me), can't type. 😛

Fixed

banwidth, row size, no way to know.

Send 1000 records as a test. Extrapolate.

This isn't really the place for this, and we don't want .SQLs up there for safety.

Adam, really you should submit this as a script, and there are comment sections for...

Microsoft licenses and checks sockets, not cores. SQL will use all 8 cores, you'll need 2CPU licenses if you go that way.

Good luck and let us know if it works!

You should read about backup and recovery in Books Online or on this site. We have a backup and recovery section in the articles section:http://www.sqlservercentral.com/Articles/Backup+and+Recovery/

There is a lot to understand...

Transactional is just that, replication by transaction. You can slow it down, but it works fine for continuous transactions as well.

Always a bandwidth/resource issue, but if you have enough, it...

Had no problems here. I grabbed the ISO, captured as the CD drive in a VM, and the install ran with no issues.

When in doubt, VM 😉