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 triggers and its types?
What are key constraints?
Explain what role entity and relationship play in an ER diagram.
How to create indexed view?
What are “lost updates”?
Where are sql server usernames and passwords stored in the sql server?
how you can get the list of largest tables in a database? : Sql server administration
What is the difference between stored procedure and user defined functions?
Explain differentiate between a having clause and a where clause?
In which sql server version report builder introduced?
How can you manage sql azure security?
Can we hide the definition of a stored procedure from a use?
What is the difference between join and inner join?
What is the difference between insensitive and scroll cursor?
Explain foreign key in sql server?