Which is the performance killer: SELECT INTO or INSERT INTO?
There are many ways to kill performance in a script or stored procedure. However, not many think about the possibility that adding columns to a temporary table can kill performance. Here, I’m going to show you how a simple design decision – using INSERT vs ALTER TABLE – can have a huge impact on your procedure …
Which is the performance killer: SELECT INTO or INSERT INTO? Read More »