How Do You Use Dbcc Statements To Monitor Various Aspects Of A Sql Se

1.	How Do You Use Dbcc Statements To Monitor Various Aspects Of A Sql Server Installation?
Answer» Database Consistency Checker (DBCC) - Is a statement USED to check the LOGICAL and physical consistency of a database, check memory usage, DECREASE the size of a database, check performance statistics, and so on. Database consistency checker (DBCC) ensures the physical and logical consistency of a database, but is not corrective. DBCC can help in repairing or checking the installation in case of any failure. Database Consistency Checker (DBCC) - Is a statement used to check the logical and physical consistency of a database, check memory usage, decrease the size of a database, check performance statistics, and so on. Database consistency checker (DBCC) ensures the physical and logical consistency of a database, but is not corrective. DBCC can help in repairing or checking the installation in case of any failure.

How Do You Use Dbcc Statements To Monitor Various Aspects Of A Sql Server Installation?

Answer»

Database Consistency Checker (DBCC) - Is a statement USED to check the LOGICAL and physical consistency of a database, check memory usage, DECREASE the size of a database, check performance statistics, and so on. Database consistency checker (DBCC) ensures the physical and logical consistency of a database, but is not corrective. DBCC can help in repairing or checking the installation in case of any failure.

Database Consistency Checker (DBCC) - Is a statement used to check the logical and physical consistency of a database, check memory usage, decrease the size of a database, check performance statistics, and so on. Database consistency checker (DBCC) ensures the physical and logical consistency of a database, but is not corrective. DBCC can help in repairing or checking the installation in case of any failure.

Discussion

No Comment Found

Related InterviewSolutions

What Does It Mean To Have Quoted_identifier On? What Are The Implications Of Having It Off?
What Is Task?
How Does You Handle This Com Components Developed In Other Programming Languages In .net?
How Do U Call And Execute A Stored Procedure In .net?
How Do You Find The Error, How Can You Know The Number Of Rows Affected By Last Sql Statement?
What Is The Stuff Function And How Does It Differ From The Replace Function?
Explain Differences Between Framework 1.0 And Framework 1.1?
What Are The Differences Between User Control And Web Control And Custom Control?
How Do Sql Server 2000 And Xml Linked? What Is Sql Server Agent?
If We Write Any Code For Datagrid Methods, What Is The Access Specifier Used For That Methods In The Code Behind File And Why And How? Give An Example?