January 19, 2014 at 5:59 am
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 19, 2014 at 4:51 pm
Nice n easy thanks.
Hope this helps...
Ford Fairlane
Rock and Roll Detective
January 20, 2014 at 12:19 am
Good one, thanx.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
January 20, 2014 at 1:16 am
Very easy one!!! ... after reading BOL!
😀
January 20, 2014 at 2:26 am
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:
January 20, 2014 at 2:27 am
Godd qotd to start the week.
January 20, 2014 at 3:26 am
Thanks for the question,
Since you cannot backup tempdb, it doesn't make much sense to be able to change the recovery model 😀
January 20, 2014 at 4:55 am
This was removed by the editor as SPAM
January 20, 2014 at 12:08 pm
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.
January 20, 2014 at 4:29 pm
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
January 21, 2014 at 7:57 am
Good Question, made me feel good about all those sessions I attended on the TempDB.
January 26, 2014 at 11:14 pm
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."
January 27, 2014 at 3:23 am
Good one as wasn't aware of all of them. Thanks free mascot. 🙂
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply