Interested to Buy Any Domain ? << Click Here >> for more details...
As a part of your job, what are the DBCC commands that you
commonly use for database maintenance?
- 1 Answers
- 8357 Views
- HCL, I also Faced
- E-Mail Answers
Answer / swapna
DBCC CHECKDB, DBCC CHECKTABLE, DBCC CHECKCATALOG, DBCC
CHECKALLOC, DBCC SHOWCONTIG, DBCC SHRINKDATABASE, DBCC
SHRINKFILE etc.
| Is This Answer Correct ? | 5 Yes | 0 No |
what's new in sql server 2016?
How to determine the service pack currently installed on SQL Server?
Which is better statement or preparedstatement?
what is index seek and index scan?
What is query and its types?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What is the difference between local and global temporary tables?
What are the types of database schema? : sql server analysis services, ssas
How will you monitor replication latency in transactional replication? : sql server replication
Tell me what is use of except clause? How it differs from not in clause?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
what is differece between union and union all
-
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)
