tommyh (10/3/2011)

---

There are several problems with this question. One being that you cant declare @Start 2 times.

The other being that the answer is wrong. They both perform equally. I have executed the query as is (though with the @Start thing dealt with). With the 2 queries in the opposit order and one at a time. And the time is always roughly 100ms result (give or take 10ms).

I get the same execution plan (2005) for both queries. So im hoping that someone with more knowledge then me can enlighten us.

/T

Carlo Romagnano (10/3/2011)

---

You should execute the two batch separately, so, you can declare @Start twice.
But, I agree with you: the answere is wrong and hardly to establish which perform better.

stewartc-708166 (10/3/2011)

---

Interesting question, Ron.
Thanks

Something to bear in mind: There are numerous factors that influence the choice between table variables and/or temp tables, inter alia:
> Data set size (number of columns and rows) - larger datasets work better with temp tables (mainly because these can be indexed);
> Availalbe memory vs available drive space (file swapping etc);
> IO's;
> Persistence (using the data set in other stored procedures)
> UDF - one can only use table variables in UDF's

tommyh (10/3/2011)

---

There are several problems with this question. One being that you cant declare @Start 2 times.

The other being that the answer is wrong. They both perform equally. I have executed the query as is (though with the @Start thing dealt with). With the 2 queries in the opposit order and one at a time. And the time is always roughly 100ms result (give or take 10ms).

I get the same execution plan (2005) for both queries. So im hoping that someone with more knowledge then me can enlighten us.

/T