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

What does it mean to manipulate data?

1001


What is cursor in ms sql server?

1153


What is the beast way to write CTE in SQL Server ?

1047


What is a trace frag? Where do we use it?

1100


Can a rule be bound to any column of any data type?

963


What is the difference between a check constraint and a rule?

1256


When we should use and scope of @@identity?

999


How to generate random numbers with the rand() function in ms sql server?

1155


What are views in ms sql server?

1087


What is the difference between getdate and sysdatetime?

1013


What is a trigger? Why we need it?

999


what is a deadlock? : Sql server database administration

1072


What is ddl command?

986


What is implicit cursors?

1088


What is the difference between char, varchar and nvarchar?

1024