What is blocking and how would you troubleshoot it?

Answer Posted / rajendra kumar

Select Blocked from Master..sysprocesses Where Blocked <>0

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain “not null constraint” in sql server?

723


Can we delete data from a view?

709


Detail about query optimizer?

801


What are transactions in sql?

737


How to choose all records from the table?

798






What does ss stand for sexually?

794


What are the differences between having and where clause.

709


Can we hide the definition of a stored procedure from a use?

870


what are the important architecture components of SSRS?

112


How to create database with physical files specified in ms sql server?

724


What is the purpose of linked server configuration in sql server?

726


How to copy the tables, schema and views from one sql server to another?

740


Explain the database you used in your final year project?

712


What are indexes in ms sql server?

717


How is sql server used?

692