How do you use DBCC statements to monitor various aspects of
a SQL server installation?
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 stretch database in sql server?
Can select statements be used on views in ms sql server?
what is difference between primary key and Unique
How do triggers work?
When would you use it?
What is @@error in sql?
Can we insert data into view sql server?
How to delete multiple rows with one delete statement in ms sql server?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What is a db view?
How to use wildcard characters in like operations in ms sql server?
what is memory-optimized nonclustered indexes