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
Explain the microsoft sql server delete command? : SQL Server Architecture
What are translations and its use? : sql server analysis services, ssas
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
wat wil hapn if we give the both read and deny read permission to user?
Can two tables have the same primary key?
What purpose does the model database server?
What are “lock” hints?
How column data types are determined in a view?
What are scheduled tasks in sql server?
what is sql injection in sql server?
How to get number of days in a given year?
what is the disadvantage of SQL Loder?
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)