Interested to Buy Any Domain ? << Click Here >> for more details...
How do you use DBCC statements to monitor various aspects of
a SQL server installation?
- 1 Answers
- 7414 Views
- I also Faced
- E-Mail Answers
DBCC stands for database consistency checker. We use these
commands to check the consistency of the databases, i.e.,
maintenance, validation task and status checks.DBCC
CHECKDB - Ensures that tables in the db and the indexes are
correctly linked.and DBCC CHECKALLOC To check that all
pages in a db are correctly allocated. DBCC SQLPERF - It
gives report on current usage of transaction log in
percentage. DBCC CHECKFILEGROUP - Checks all tables file
group for any damage.
| Is This Answer Correct ? | 3 Yes | 1 No |
What action plan is preferred if sql server is not responding?
How can you know if the row fetched from cursor is still valid in underlying table?
What are various aggregate functions that are available?
Define magic tables in sql server?
What is the diffrence between update_one and auto_fix?
What is an indice?
What is forward - only cursors / read only cursor?
What is role playing dimension with two examples? : sql server analysis services, ssas
What is policy management?
How to create an identity column?
What is tcl in sql server?
Does an index slow down updates on indexed columns?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
