As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
Submitted by: AdministratorDBCC CHECKDB,
DBCC CHECKTABLE,
DBCC CHECKCATALOG,
DBCC CHECKALLOC,
DBCC SHOWCONTIG,
DBCC SHRINKDATABASE,
DBCC SHRINKFILE etc.
But there are a whole load of DBCC commands which are very useful for DBAs.
Submitted by:
DBCC CHECKTABLE,
DBCC CHECKCATALOG,
DBCC CHECKALLOC,
DBCC SHOWCONTIG,
DBCC SHRINKDATABASE,
DBCC SHRINKFILE etc.
But there are a whole load of DBCC commands which are very useful for DBAs.
Submitted by:
Read Online SQL Server Database Administrator Job Interview Questions And Answers
Top SQL Server Database Administrator Questions
☺ | How to trace the traffic hitting a SQL Server? |
☺ | What is DBCC? |
☺ | What is lock escalation? |
☺ | Is SQL Server implemented as a service or an application? |
☺ | What are isolation levels? |
Top New MS SQL Server Categories
☺ | SQL Server Database Administrator Interview Questions. |
☺ | SQL Server Service Broker Interview Questions. |
☺ | SQL Server Locks Interview Questions. |
☺ | SQL Server Constraints Interview Questions. |
☺ | MS SQL Data Mining Interview Questions. |