As a part of your job, what are the DBCC commands that you
commonly use for database maintenance?
Answer Posted / swapna
DBCC CHECKDB, DBCC CHECKTABLE, DBCC CHECKCATALOG, DBCC
CHECKALLOC, DBCC SHOWCONTIG, DBCC SHRINKDATABASE, DBCC
SHRINKFILE etc.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
if no size is defined while creating the database, what size will the database have? : Sql server administration
What are security principals used in sql server 2005?
How many types of schemas are there?
How can I check if a view exists in a sql server database?
Explain atomicity?
What is mean by dml?
What is the meaning of resultset type_scroll_insensitive?
Is it possible for a stored procedure to call itself or recursive stored procedure?
How to populate a table in sql server?
What stored by the tempdb ? : sql server database administration
what is denormalization? : Sql server database administration
What are the differences between decimal and float in ms sql server?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What are the different SQL Server Versions you have worked on?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?