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.
No Answer is Posted For this Question
Be the First to Post Answer
What are filegroups in sql server?
What is the difference between cartesian product and cross join?
What is the difference between sdf and mdf?
How to create a dynamic cursor with the dynamic option?
what are the different types of replication you can set up in sql server? : Sql server database administration
What is sql stored procedure?
How to Install SQL SERVER 2005 remotely?
What is difference between count (*) and count column?
How to trouble shoot if unable to connect SQL Server
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What is the difference between dbcc indexdefrag and dbcc reindex?
Tell me about the approaches which you used to counter the DI problems.
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)