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

Diff b/w Temp tables varibles and CTE's Expand / Collapse
Author
Message
Posted Tuesday, April 2, 2013 9:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 22, 2013 5:46 AM
Points: 6, Visits: 24
Hi guys
i have a doubt abut temp table and CT E's
which one is faster and why,in which sceniro we will go for this one can u briefly explain this topics with simple examples

And can u briefly explain the Derived tables
Post #1437972
Posted Tuesday, April 2, 2013 10:00 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:32 PM
Points: 13,455, Visits: 12,318
Try this.

http://www.sqlservercentral.com/Forums/Topic415829-338-1.aspx


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1437985
Posted Thursday, April 4, 2013 2:08 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 2:03 PM
Points: 80, Visits: 350
I have a whole presentation with TSQL examples on temporary objects.

Coverage:

1 – Derived tables.
2 – Local temporary tables.
3 – Global temporary tables.
4 – Table variables.
5 – Common Table Expressions (CTE).
6 – User databases in [tempdb].
7 – Trace Flag 1118.


http://craftydba.com/?page_id=880

Enjoy ...



John Miner
Crafty DBA
www.craftydba.com
Post #1439005
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse