Search:     Advanced search
Browse by category:
C/C++   |   Java   |   Oracle/Database   |   SAP   |   ASP .NET   |   Mainframe-DB2   |   Freshers

What is use of DBCC Commands?

Add comment
Views: 76
Votes: 0
Comments: 0
The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for SQL Server.  DBCC commands are used to perform following tasks.

Maintenance tasks on database, index, or filegroup.
Tasks that gather and display various types of information.
Validation operations on a database, table, index, catalog, filegroup, or allocation of database pages.
Miscellaneous tasks such as enabling trace flags or removing a DLL from memory.
Others in this Category
document What is CHECK Constraint?
document How would you handle error in SQL SERVER 2008?
document What is User Defined Functions? What kind of User-Defined Functions can be created?
document What is a table called, if it has neither Cluster nor Non-cluster Index? What is it used for?
document What is a Linked Server?
document What is CTE?
document What are different normalization forms?
document What is sub-query? Explain properties of sub-query?
document What are different Types of Join?
document Q: What are the properties of the Relational tables?
» More articles



RSS