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 123»»»

Non Temp Temp Tables Expand / Collapse
Author
Message
Posted Saturday, July 19, 2014 3:45 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:12 AM
Points: 33,266, Visits: 15,432
Comments posted to this topic are about the item Non Temp Temp Tables






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1594340
Posted Sunday, July 20, 2014 10:46 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:05 AM
Points: 13,724, Visits: 10,680
Easy on, thanks!



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1594405
Posted Monday, July 21, 2014 12:15 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Sunday, September 7, 2014 10:22 PM
Points: 1,126, Visits: 1,387
Easy one, thanks

Thanks
Post #1594441
Posted Monday, July 21, 2014 1:10 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 4:15 AM
Points: 663, Visits: 212
Easy One. :)
But i think it is rather unusual, tempdb is completely wiped out whenever the SQL Server service restarts. Yes or No?
Post #1594459
Posted Monday, July 21, 2014 1:37 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 11:58 PM
Points: 743, Visits: 1,309
Sreepathi1987 (7/21/2014)
Easy One. :)
But i think it is rather unusual, tempdb is completely wiped out whenever the SQL Server service restarts. Yes or No?


The answer is Yes.

Nice and easy question, but still tricky if you have never created a table in tempdb before. So Thanks for sharing Steve.
Post #1594469
Posted Monday, July 21, 2014 1:44 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, September 12, 2014 9:43 AM
Points: 7,284, Visits: 13,824
Sreepathi1987 (7/21/2014)
Easy One. :)
But i think it is rather unusual, tempdb is completely wiped out whenever the SQL Server service restarts. Yes or No?


Yes, which makes tempdb useful as an experimental sandbox. If you forget to clear up your tables, SQL Server will do it for you.


“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1594472
Posted Monday, July 21, 2014 2:28 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 5:34 AM
Points: 3,956, Visits: 5,188
Good question, thanks Steve.

ChrisM@Work (7/21/2014)
Sreepathi1987 (7/21/2014)
Easy One. :)
But i think it is rather unusual, tempdb is completely wiped out whenever the SQL Server service restarts. Yes or No?


Yes, which makes tempdb useful as an experimental sandbox. If you forget to clear up your tables, SQL Server will do it for you.


Only when SQL Server next restarts, however. It is, therefore , possible to fill tempdb with experiments if it is not restarted in good time...



____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1594489
Posted Monday, July 21, 2014 3:46 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 10:39 AM
Points: 1,194, Visits: 787
easy one on monday morning
Post #1594508
Posted Monday, July 21, 2014 5:26 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 6:34 AM
Points: 593, Visits: 218
ChrisM@Work (7/21/2014)
Sreepathi1987 (7/21/2014)
Easy One. :)
But i think it is rather unusual, tempdb is completely wiped out whenever the SQL Server service restarts. Yes or No?


Yes, which makes tempdb useful as an experimental sandbox. If you forget to clear up your tables, SQL Server will do it for you.


Now the question becomes useful for me. Thanks..
Post #1594527
Posted Monday, July 21, 2014 7:15 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:32 AM
Points: 21,734, Visits: 15,425
Sreepathi1987 (7/21/2014)
Easy One. :)
But i think it is rather unusual, tempdb is completely wiped out whenever the SQL Server service restarts. Yes or No?


Mostly yes.

If there is corruption in tempdb, that corruption will persist after a service restart. At that point, you have to manually drop tempdb files.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1594580
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse