Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 2 Answers
- 5627 Views
- I also Faced
- E-Mail Answers
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
Can you please differentiate between a primary key and a unique key?
Explain tablesample?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What is check constraint in sql server?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
How to add an address record into adventureworkslt?
How to apply cascading referential integrity in place of triggers?
How to count groups returned with the group by clause in ms sql server?
If a stored procedure is taking a table data type, how it looks?
What is tempdb in sql server?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
In what three ways is the return statement used in a stored procedure?
What are the differences between clustered and non-clustered index?
What is sharding?
Explain a checkpoint?
