Explain some DBCC commands?

Answer Posted / varun

dbcc opentran,dbcc inputbuffer,dbcc outputbuffer.

Is This Answer Correct ?    9 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is triggers and its types?

725


How do I open port 1433?

692


What are the common performance issues in sql server?

659


Write a sql query to sort on different column name according to the parameters passed in the function?

693


Explain the difference between control flow and data flow?

697






How can we rewrite sub-queries into simple select statements or with joins?

703


Which is the latest version of sql server and when it is released?

745


How to make a remote connection in a database?

700


What is the report model project?

122


Explain few of the new features of sql server 2008 management studio

681


Explain left outer join and right outer join?

757


What is the cpu pressure?

762


Can you use order by when defining a view?

726


Determine when an index is appropriate?

745


Explain what is the difference between a local and a global temporary table?

702