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
- 8545 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 |
Give main differences between "Truncate" and "Delete".
wat new abt truncate in sql server
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
What is dbcc?
What is dirty read?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What is temporary stored procedure?
What are acid properties of transaction?
Explain what is row_number function?
Please differentiate between a local and a global temporary table?
What are the factors you will check for the performane optimization for a database query?
7 Answers CarrizalSoft Technologies, DELL, SoftSol,
Can we write trigger for view?
-
Oracle (3253) - 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)
