Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Triggers

Author  Topic 

dineshrajan_it
Posting Yak Master

217 Posts

Posted - 2008-03-15 : 07:09:32
Does CTE's out perform temporary table in Sql server 2005. but in my sp its just the opposite. why?

dataguru1971
Master Smack Fu Yak Hacker

1464 Posts

Posted - 2008-03-15 : 10:28:15
Post the sp....Probably something in the code that can be improved for optimizing performance.




Poor planning on your part does not constitute an emergency on my part.

Go to Top of Page
   

- Advertisement -