Interested to Buy Any Domain ? << Click Here >> for more details...
How do you use DBCC statements to monitor various aspects of
a SQL server installation?
- 1 Answers
- 7456 Views
- I also Faced
- E-Mail Answers
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 |
Define right outer join?
What is the difference between a stored procedure and a user defined function in sql server?
What is Command line parameters in PLSQL.?
Explain the difference between function and stored procedure?
What is normalization and what are the advantages of it?
What is normalization 1nf 2nf 3nf?
Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?
default databases available in sql server and there uses ?
How would you add a section to a table?
Tell about MOM Tool(Microsoft Operator Manager)?
how to define testing of network layers? : Sql server database administration
How many non clustered indexes there can be on table ?
-
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)
