February 21, 2012 at 4:03 am
what is best for performance prospective temp table or table variable ?thanks in advance.
February 21, 2012 at 4:05 am
you will definitely get the answer from this blog.
http://www.sql-server-performance.com/2007/temp-tables-vs-variables/
February 21, 2012 at 4:31 am
sengeet86 (2/21/2012)
you will definitely get the answer from this blog.http://www.sql-server-performance.com/2007/temp-tables-vs-variables/
That article is wrong in several places, better not to depend on it.
http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/
and
http://www.sqlservercentral.com/articles/Temporary+Tables/66720/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 19, 2012 at 2:17 pm
I like to use variable tables however, for me it all depends on what your script is doing. i usually create a script using both methods my self and then test the performance of each script.
do you need a temp table of any kind can you complete your task using CTE,
***The first step is always the hardest *******
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply