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 and how would you troubleshoot it?

Answer Posted / swapna

Blocking happens when one connection from an application
holds a lock and a second connection requires a conflicting
lock type. This forces the second connection to wait,
blocked on the first.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Find nth lowest salary or get nth lowest salary?

1029


Explain different types of lock modes in sql server 2000?

931


How sql server enhances scalability of the database system?

1215


What is the difference between stored procedure and user defined functions?

1190


What command do we use to rename a db, a table and a column?

927


What is the report builder?

139


What are different backups available in sql server?

1070


What are points to remember while using the fillfactor argument?

970


Explain the steps needed to create a scheduled job?

930


Explain what are magic tables in sql server?

994


Which is better statement or preparedstatement?

924


What are extended events in sql server?

955


What's the information that can be stored inside a bit column?

1004


Is there any difference between primary key and unique with the not null condition?

946


What is the difference between char, varchar and nvarchar?

1022