Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

Common Table Expressions in SQL Server 2005 Expand / Collapse
Author
Message
Posted Sunday, March 11, 2007 11:59 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, November 24, 2011 1:55 AM
Points: 139, Visits: 43

Nice article. Cleared a lot of grey areas regarding CTE for me.

I have a doubt though, given the uses of a CTE, isint it similar to table variables then? I mean where is the result stored and how performant is a CTE as copmared to a table variable.

Pardon my ignorance if I am asking a question which should have an obvious answer.




What I hear I forget, what I see I remember, what I do I understand
Post #350618
Posted Tuesday, May 13, 2008 8:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 23, 2013 2:48 PM
Points: 2, Visits: 43
Well you are not alone I am also wondering how a CTE compares to a table variable performance wise.

Thank You
Post #499618
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse