Can you give me some DBCC command options?(Database
consistency check) - 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.
- 0 Answers
- 2035 Views
- iSoft, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between HAVING clause and the WHERE clause?
What’s the distinction between dropping a info and taking a info offline?
What do you understand by replication in sql server?
Define master database?
After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?
How to create a view on an existing table in ms sql server?
Why use identity in sql server?
What are the advantages of paper records?
How to insert data into an existing table?
To find second largest salary in Employee table
What does COMMIT command do?
Can we write ddl in trigger?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
