Cleaning up tempdb

Question

Post reply

Cleaning up tempdb

Steve Jones - SSC Editor

SSC Guru

Points: 736255
More actions
March 22, 2019 at 12:14 am

#77686

Comments posted to this topic are about the item Cleaning up tempdb

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

HappyGeek SSCoach Points: 18729 More actions · Answer 1

Good question and nice follow up given the comments on the previous question on tempdb, thanks Steve.

...

Shayn Thomas SSCertifiable Points: 5863 More actions · Answer 2

cheers steve, good question

---------------------------------------------------------------------------------------
The more you know, the more you know that you dont know

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 3

This is one of those questions where "It Depends" comes into play... please see the following article where the supposedly correct answer didn't work...
https://www.sqlskills.com/blogs/erin/remove-files-from-tempdb/

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Stewart "Arturius" Campbell SSC Guru Points: 72627 More actions · Answer 4

Interesting question, thanks, Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”