SQL Server Performance Forum – Threads Archive
Temp table
hi ,<br /> we are using temp table is our stored procedure, i heard that temp table affected over all Sql server performance , please help to know what are draw back while using temp table s<br /><br />Thanks<br />R.Raja<br />Chennai- India<br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]
As you have already mentioned, temp tables hurts SQL server performance and it is major drawback.
Read about table variables in BOL which can be used in some situations over temp tables.
Also based on procedure figure out, whether it really needs temp tables intervention.
please explain in breif
any body give some useful links about temp table
[?]
its again a FAQ
http://toponewithties.blogspot.com/2004_08_01_toponewithties_archive.html
http://www.sqlteam.com/item.asp?ItemID=2029
http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx
quote:Originally posted by rajaragothaman
any body give some useful links about temp table
[?]
[?]
have you googled for this? Also have you looked into BOL for some more relevant information
Is this related to SQL Server 2005 or 2000? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>