Click here to Skip to main content
15,881,281 members
Articles / Database Development / SQL Server

Temporary Tables vs. Table Variables and Their Effect on SQL Server Performance

Rate me:
Please Sign up or sign in to vote.
4.81/5 (40 votes)
28 May 20074 min read 354.2K   88  
Determining SQL Server performance for temporary tables and and table variables.

Views

Daily Counts

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


Written By
Russian Federation Russian Federation
Born in 1968, Dmitry Tsuranoff is SQL professional who addresses issues and problems from the perspective of both a database developer and a DBA. He has worked in the United States, France and Russia. Currently, he is employed as Systems Architect and Team Manager at Lakeside Technologies, developer of high-performance Lakeside SQL Server Tools.

For more information, please visit http://www.lakesidesql.com.

Comments and Discussions