Tagged: Performance

1

INSERT INTO vs SELECT INTO

Introduction What is faster to use… INSERT INTO or SELECT INTO? I have read many blog posts comparing INSERT INTO to SELECT INTO, yet so many still get it wrong. In this post, I will provide the full picture of performance differences between INSERT INTO and SELECT INTO and how...

2

INSERT INTO vs SELECT INTO (Detailed)

Into to Detailed Breakdown As mentioned in the previous main post, below is a detailed comparison between INSERT INTO & SELECT INTO from SQL Server 2012 up to 2017 using temporary tables. The Testing Scripts Used Below you can find the testing scripts which were executed on each version of...