Microsoft® SQL Server® 2012 Bible

587 Chapter 22: Maintaining the Database 22 Result: checkalloc checkcatalog checkconstraints checkdb checkfilegroup checkident c ...

588 Part V: Enterprise Data Management proccache show_statistics showcontig shrinkdatabase shrinkfile sqlperf traceoff traceon t ...

589 Chapter 22: Maintaining the Database 22 DBCC results for 'sys.sysrscols'. There are 1406 rows in 14 pages for object "sys.sy ...

590 Part V: Enterprise Data Management successful completion, column-value integrity checks are enabled for the database, and yo ...

591 Chapter 22: Maintaining the Database 22 If the AUTO_UPDATE_STATISTICS_AYSNC option for the database is set to ON, you can pl ...

592 Part V: Enterprise Data Management DBCC results for 'Production.TransactionHistoryArchive'. There are 89253 rows in 620 page ...

593 Chapter 22: Maintaining the Database 22 If the database requires repair, always use the full DBCC CHECKDB rather than one of ...

594 Part V: Enterprise Data Management DBCC CHECKDB also runs DBCC CHECKALLOC, DBCC CHECKTABLE, and DBCC CHECKCATALOG, so you do ...

595 Chapter 22: Maintaining the Database 22 The following stored procedure adds 100,000 rows each time it’s executed: CREATE PRO ...

596 Part V: Enterprise Data Management The sys.dm_db_index_physical_stats function requires an Intent-Shared (IS) table lock reg ...

597 Chapter 22: Maintaining the Database 22 Result (abridged): index_id: 1 index_type_desc: CLUSTERED INDEX avg_fragmentation_in ...

598 Part V: Enterprise Data Management To view operational index statistics, query the sys.dm_db_index_operational_stats dynamic ...

599 Chapter 22: Maintaining the Database 22 Database File Size SQL Server 7.0 moved beyond SQL Server 6.5’s method of allocated ...

600 Part V: Enterprise Data Management Result: database_name database_size unallocated space ------------------ ---------------- ...

601 Chapter 22: Maintaining the Database 22 has been removed from the database, and the database is not confi gured to automatic ...

602 Part V: Enterprise Data Management The results show that not all the fi les had space to reclaim. The command tells you whic ...

603 Chapter 22: Maintaining the Database 22 Name : user_transaction LSN : (42:228:1) Start time : May 30 2012 7:31:53:077PM SID ...

604 Part V: Enterprise Data Management ■ (^) DBCC FREESYSTEMCACHE: Clears the unused cache entries from all caches. It also clea ...

605 Chapter 22: Maintaining the Database 22 Planning Database Maintenance Database maintenance plans include the following routi ...

606 Part V: Enterprise Data Management Adding a Task A maintenance plan must contain at least one task. Fortunately, it isn’t ha ...