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 ««12

TempDB Expand / Collapse
Author
Message
Posted Friday, August 20, 2010 10:02 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 11:47 AM
Points: 1,676, Visits: 1,759
Good question, thank you. I got it wrong because sadly I did not read the question carefully enough, and performed was the key. Running it does not produce any error, i.e.

use tempdb;
go

dbcc checkalloc with no_infomsgs;
go

reports "Command(s) completed successfully."

The question asked performed not ran, and BOL's verdict is clear:

In SQL Server 2005 and later, running DBCC CHECKALLOC against tempdb does not perform any checks.


Oleg
Post #972658
Posted Friday, August 20, 2010 12:17 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:45 PM
Points: 17,947, Visits: 15,941
Thanks for the question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #972741
Posted Friday, September 17, 2010 1:05 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 12, 2013 2:07 PM
Points: 168, Visits: 38
It has more that can't perform like:
Adding filegroups and Backing up or restoring the database
Post #988515
Posted Wednesday, March 7, 2012 1:37 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 10:52 PM
Points: 483, Visits: 244
Interesting question on the TempDB. Back to basics and the url below under the 'Restrictions' states all the facts too.

URL: http://msdn.microsoft.com/en-us/library/ms190768.aspx

Thanks
Post #1263261
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse