Home Forums SQL Server 2005 T-SQL (SS2K5) Why INSER INTO ... UNION ALL? RE: Why INSER INTO ... UNION ALL?
Bruce W Cassidy
SSChampion
Points: 12668
More actions
March 10, 2009 at 6:21 pm
#957186
florian.reischl (3/10/2009)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..?
florian.reischl (3/10/2009)
[font="Verdana"]Probably dependant on the database recovery model.[/font]