Derived Tables Vs Views Vs Table Variables 1

[FatalExceptionError]

Anyone in here have any links or know where I can read up on the differences between derived tables, views and table variables. I am more concerned with performance issues and I am pretty sure it comes down to the anticipated size of the data and what kind of machine it is on, but I would just like to read others thoughts as well.

=======================================
The statement below is true
The statement above is false

There are 10 kinds of people, those who know binary and those who don't

 

[SQLSister]

Performance tuning is a complicated subject. I think you would find more in depth information in books rather than Internet links. This FAQ has some good books on performance tuning:

http://www.tek-tips.com/faqs.cfm?fid=3324

Questions about posting. See faq183-874

 

[FatalExceptionError]

Hotdamn sister I love you. Exactly what I was looking for + tax.

=======================================
The statement below is true
The statement above is false

There are 10 kinds of people, those who know binary and those who don't