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: 2 days ago @ 3:11 PM
Points: 31,368, Visits: 15,837
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 @ 5:04 AM
Points: 13,641, Visits: 11,514
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: Thursday, November 20, 2014 5:13 AM
Points: 1,131, Visits: 1,394
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: 686, 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
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, December 19, 2014 3:33 AM
Points: 856, Visits: 1,506
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: Thursday, December 18, 2014 1:43 AM
Points: 6,890, Visits: 14,254
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:08 AM
Points: 4,160, Visits: 5,557
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: Wednesday, December 10, 2014 10:49 AM
Points: 1,194, Visits: 791
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: Thursday, September 18, 2014 2:30 AM
Points: 595, Visits: 219
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, December 19, 2014 3:20 PM
Points: 18,064, Visits: 16,099
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1594580
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse