Our main production SQL Servers consist of:

2 Dell R900s 4 x 4 core in Active/Active cluster, Windows Server 2008, SQL 2008 SP1, 256GB each, supporting

~400 databases totaling 3.5TB.

2 new...

Based on the example above, you could explore some new features such as multiple row inserts and CTEs with OVER and PARTITION BY, to accomplish the same thing. Obviously...