navigation
 Thursday, November 16, 2006
Temp Tables vs. Table Variables in SQL Server 2000 and 2005

This is an interesting article about the performance and scalability of temp table and table variable in SQL Server 2000 and 2005. http://www.lakesidesql.com/articles/?p=12

posted on November 16, 2006  #    by Adam Anderson  Comments [0] Trackback
Related posts:
T-SQL: How To Obtain SCOPE_IDENTITY() From an Object With an INSTEAD OF INSERT Trigger
T-SQL: A Simple Way to Build a String from a Column
T-SQL: How to Invert a Bit
Get More Out of Your Foreign Keys
How To Write Secure Dynamic SQL
Good article about some lesser-known differences between temp tables and table variables
Name
E-mail
Home page

Comment (Some html is allowed: a@href@title, i, strike, u) where the @ means "attribute." For example, you can use <a href="" title=""> or <blockquote cite="Scott">.  

Enter the code shown (prevents robots):
Live Comment Preview

Copyright © 2003-2008 Falafel Software Inc.