Execute the query a bunch.;-) See what you get each time you execute...

Make My Day, Punk!

Dave62 (11/5/2014)

---

Brian.Klinect (11/5/2014)

---

I forgot RAND() was exclusive. So we can get .99999..., which multiplies to 9.999999..... I take it then that storing a floating point number as an...

Pistol

Sarcasm at Summit? No not possible...

Hope to see you around at some point.

Pole

stream

ronmoses (11/3/2014)

---

Yes, I agree this seemed fairly obvious, but the fact that there are three correct answers (the first three options are all true) and I'm only permitted to choose...

DrKiller (11/2/2014)

---

+1, didn't really know its possible (well just never thought of...

meander

As Gail said, whoever told you that is wrong.

Although one could possibly misconstrue that a backup is larger if they only look at the on disk size of a file...

I appreciate the question. I seldom, if ever, think to perform the query in the second fashion.

Can you provide examples of the various different lengths you are seeing?

Try the demos in this article.

http://blogs.office.com/2010/06/07/running-a-sql-stored-procedure-from-excel-no-vba/

No you cannot force a table variable to be memory only.

And since they don't have statistics, you are still looking at a performance problem - most of the time -...