Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is blocking in SQL Server? If this situation occurs how
to troubleshoot this issue

Answer Posted / shyamsri83

When one transaction is trying to access a record, which is
used by other, then the first transaction has to wait,
untill the second transaction complete. This is called
blocking.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain external key management in sql server 2008

892


Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1607


What is update locks?

893


let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

956


How many types of functions are there in sql server?

948


What part does database design plays a role in performance of an sql server-based application?

988


How many types of triggers are there?

1068


What are the differences between sql server and mysql.

1101


What are dml triggers and types of dml triggers?

983


What are the differences between left join and inner join in sql server?

1110


Explain how many types of relationship?

1031


How to find tables without indexes?

1090


When you should use a low fill factor?

994


Explain transaction server isolation?

1047


What is encryption key?

132