Thanks Brandie,

Both articles were awesome and in depth.

Each led to other articles that helped greatly.

This is my first post here and I must say, I'm very impressed!!!

Thanks again,

What about issues of memory usage on temp tables or table variables.

Is there a difference?

i.e. does a temp table (#mytable) write to the disk in tempdb?

vs. a table variable (@mytable)...