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
- 7354 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 is sql collation?
Write an sql query to find first weekday of the month?
Where to find ntwdblib.dll version 2000.80.194.0?
How can a database be repaired?
What protocol does sql server use?
How to locate and take substrings with charindex() and substring() functions?
how do we insert 100 records at a time in a table without using for loop in database
What is function of CUBE ?
Which table keeps the locking information?
How does normalization work?
Explain comment on transactions?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
-
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)
