|
DBCC |
| Top 3 Resources | |
| Resource | Useful SQL Server Commands |
| Resource | Edgewood Solutions |
| Resource | SQL Server 2005 DBCC Commands |
| Quick Reference - 2000k | |
| CheckTable | DBCC CHECKTABLE('Table Name') |
| CheckcDB | DBCC CHECKDB('Database Name') |
| CheckIdent | DBCC CHECKIDENT(tableName) |
| CheckIdent | DBCC CHECKIDENT(tableName, NORESEED) |
| CheckIdent | DBCC CHECKIDENT(tableName, RESEED, 5920) |
| CacheStats | DBCC CACHESTATS |
| DropCleanBuffers | DBCC DROPCLEANBUFFERS |
| ErrorLog | DBCC ERRORLOG |
| IndexDefrag | DBCC INDEXDEFRAG (Database_Name, Table_Name, Index_Name) |
| FreeProcCache | DBCC FREEPROCCACHE |
| MemoryStatus | DBCC MEMORYSTATUS |
| Page | DBCC PAGE ({dbid|dbname}, pagenum [,print option] [,cache] [,logical]) |
| Show Statistics | DBCC SHOW_STATISTICS (table_name, index_name) |
| ShrinkFile | DBCC SHRINKFILE('filename', sizeto) mdf or ldf extensions |
| OpenTran | DBCC OPENTRAN |
| DbReindex | DBCC DBREINDEX('Table Name') |
| Code | |
| Statistics | sp_msforeachtable"update statistics ? with fullscan" |
| DbReindex |
use databasename go sp_msforeachtable"dbcc dbreindex('?')" go |
| sp_lock |
Exec sp_lock |