scarydba.com
There Is No Difference Between Table Variables, Temporary Tables and Common Table Expressions - Grant Fritchey
I actually saw the above statement posted online. The person making the claim further stated that choosing between these three constructs was “personal preference” and didn’t change at all the way SQL Server would choose to deal with them in a query. Let’s immediately say, right up front, the title is wrong. Yes, there are very distinct differences between these […]
Grant Fritchey