Tempdb

Question

Tempdb

free_mascot

One Orange Chip

Points: 27169
More actions
January 18, 2014 at 1:27 pm

#303421

Comments posted to this topic are about the item Tempdb
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 20, 2014 at 4:55 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 15 total)

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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

Easy one, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 2

Nice n easy thanks.

Hope this helps...

Ford Fairlane
Rock and Roll Detective

Hany Helmy SSChampion Points: 13921 More actions · Answer 3

Good one, thanx.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Carlo Romagnano SSC-Insane Points: 22680 More actions · Answer 4

Carlo Romagnano

SSC-Insane

Points: 22680

January 20, 2014 at 1:16 am

#1681445

Very easy one!!! ... after reading BOL!

😀

Richard Warr SSCertifiable Points: 6967 More actions · Answer 5

Well, like 50% of respondents I got it wrong (wasn't too sure on the .ndf option). Nice to learn that it was a really simple question though :Whistling:

paul s-306273 SSChampion Points: 10730 More actions · Answer 6

paul s-306273

SSChampion

Points: 10730

January 20, 2014 at 2:27 am

#1681459

Godd qotd to start the week.

SQLDoubleG Hall of Fame Points: 3100 More actions · Answer 7

Thanks for the question,

Since you cannot backup tempdb, it doesn't make much sense to be able to change the recovery model 😀

Thomas Abraham SSChampion Points: 10761 More actions · Answer 8

Knew the first two were wrong, but had to make a guess (wrong) about which of the remaining five was wrong. Thanks for the question.

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

Rob Schripsema SSCertifiable Points: 7469 More actions · Answer 9

The referenced article states that you cannot perform DBCC CHECKALLOC or DBCC CHECKCATALOG on tempdb. I presumed that since DBCC CHECKDB performs both of those functions (cf. http://technet.microsoft.com/en-us/library/ms176064.aspx), one couldn't run DBCC CHECKDB against TempDB either.

But, there's a line buried in that article saying,

"Running DBCC CHECKDB against tempdb does not perform any allocation or catalog checks and must acquire shared table locks to perform table checks. This is because, for performance reasons, database snapshots are not available on tempdb. This means that the required transactional consistency cannot be obtained."

So, special handling for TempDB.

Always read the fine print....

Rob Schripsema
Propack, Inc.

TomThomson SSC Guru Points: 104773 More actions · Answer 10

Good question, but I thought it was rather easy - provided one looks for the three things which one certainly can't do to tempdb and avoids worrying about whether one can or can't do each one of the other four.

Tom

Mike Hays SSCommitted Points: 1871 More actions · Answer 11

Good Question, made me feel good about all those sessions I attended on the TempDB.

free_mascot One Orange Chip Points: 27169 More actions · Answer 12

Thank you, for your overwhelming response.

Cheers!

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

sqlnaive SSCoach Points: 17437 More actions · Answer 13

Good one as wasn't aware of all of them. Thanks free mascot. 🙂