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
What is the maximum size of sql server database?
Can group by and orderby be used together?
Which data type columns are the best candidates for full-text indexing?
What are the elements of dbms?
Write a sql query to sort on different column name according to the parameters passed in the function?
What are scalar functions?
Explain a checkpoint?
Explain triggers?
Does union all remove duplicates?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
What is difference between commit and rollback when used in transactions?
How can you list all the table constraints in a database?
What is the downside of using udf?
What is xml datatype?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?