The question which always comes up in my sessions about SQL
Server 2008 is according to my most loved feature in SQL Server
2008, the MERGE command. People always ask me how the
performance comparison with MERGE is compared to some standard /
traditional mechanisms like SQLCommand / SQLDataadapter / MERGE.
Well, for that reason I created a small test setup described in
the following:     I created a sample database containing
1.000.000 rows using the data generator from Visual Studio for
database Professional. That database should server as the basis
for the upcoming tests. I am running the etest on a virtual
machines with a non-dedicated disk for SQL IO (therefore results
may differ in your environment).   The test will do simply do
the following, having two nested loops involved:   a) Loop
through the first loop for a step in 1000n number of rows
(increasing for 1000 rows each loop).  b) Within the first loop,
do another loop, doing the mentioned stuff below for a 50n step
of datasize (increasing 50 possi