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
- 2030 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 Drop and Truncate
I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000
17 Answers HCL, IBM,
How do you Implement SSIS Packages in your Project?
Difference between: - Delete & Truncate - Table & View - Constraints & Triggers
What is blocking and how would you troubleshoot it?
What is difference between rownum and row_number?
List all types of constraints in sql server?
What is an Index?
How to create a store procedure with encryption?
How to enter binary string literals in ms sql server?
Explain error handling in ssis?
What are the source of constraints?
-
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)
