August 20, 2014 at 12:06 pm
TomThomson (8/20/2014)
Nice question.But I have one niggle :hehe:: you can't run that command against tempdb, because it is specifically acting of the database 'myDatabase' :laugh::crazy:; but it was absolutely obvious what you meant to ask so it's hard to see why so many people got that wrong :-P:laugh:. Unless of course they believe in being secure so that they normally log in as a user who doesn't have the permissions needed to run dbcc checdb against tempdb and think that QotD should be aimed at people who behave securely.
But anyway, any other choice for the second correct option was obviously wrong :w00t:, so even security lovers should have gotten it right.
And good point by you, Tom. Thanks for realizing the intention of the question and answers. I thought I finally had a rock solid question of the day!
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
August 20, 2014 at 3:04 pm
Answered too quickly on this one. I knew it could be run against tempdb but ignored that for some reason. Had I thought about it for another second then I would have second guessed my other choices and actually read the entire MSDN article! Oh well, good question.
August 21, 2014 at 12:20 am
SQLRNNR (8/20/2014) For good measure, the document is nearly the same for SQL 2014 (other areas changed but those statements were not).
http://msdn.microsoft.com/en-us/library/ms176064(v=sql.120).aspx
That helped, thx
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
August 21, 2014 at 12:25 am
Never used TABLOCK option with DBCC before, always using:
DBCC CHECKDB WITH NO_INFOMSGS, ALL_ERRORMSGS, TABLERESULTS;
DBCC CHECKDB WITH PHYSICAL_ONLY; -- Best Practice
So I had to read the documentation carefully, then answered correctly, I am one of the luckiest 22%
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
August 21, 2014 at 1:35 am
Nice question. Thanks for sharing
August 21, 2014 at 7:36 am
Hany Helmy (8/21/2014)
Never used TABLOCK option with DBCC before, always using:
DBCC CHECKDB WITH NO_INFOMSGS, ALL_ERRORMSGS, TABLERESULTS;
DBCC CHECKDB WITH PHYSICAL_ONLY; -- Best Practice
So I had to read the documentation carefully, then answered correctly, I am one of the luckiest 22%
I'd be a bit careful about calling Physical_Only a best practice. It is a check to be run on very busy systems with the full check to be run less often on that system. But the full check still has to be run on occasion somehow.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 16 through 21 (of 21 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy