Category: Performance

0

UNION vs UNION ALL

In this post, we will have a look at the differences between UNION and UNION ALL operators using Heap and Clustered Tables. For this illustration, I will use the Adventure...

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....