Hi Bob!
Bob Hovious (3/10/2009)
Flo,I'm afraid I'm unable to duplicate your results. I'm comparing an insert into/SELECT ... union all against a insert into VALUES for 1000 rows. The UNION ALL technique is running consistently faster on my machine, which I would expect because it's a single INSERT, as Bruce already stated.
Strange...! I tried on SQL Server 2005 in our company and on my SQL Server 2008. The single inserts are always faster than the union syntax..?
Bob Hovious (3/10/2009)
POST PostScript:Row Constructors [ex: Values ((1,'hello') (2,'hello'))] are new to 2008.
Oups... sorry for that. I'm currently investigating SQL Server 2008...
Thanks for your reply!
Greets
Flo