BLOCKING

I need help to understand how to minimise or completely stop blocking.
any help, tips or links will be highly appreciated. I have gone thru
couple of article about blocking but not specified how to stop
blocking. i will appreciate if some one can give me concept about
blocking & how it can be stopped. Agian any help will be highly
appreciatedA good place to start is SQL Server Books Online -> Accessing and Changing
Relational Data -> Transactions
and
SQL Server Books Online -> Accessing and Changing Relational Data -> Locking
http://msdn.microsoft.com/library/d...
ap1.asp
"myrights99@.gmail.com" wrote:

> I need help to understand how to minimise or completely stop blocking.
> any help, tips or links will be highly appreciated. I have gone thru
> couple of article about blocking but not specified how to stop
> blocking. i will appreciate if some one can give me concept about
> blocking & how it can be stopped. Agian any help will be highly
> appreciated
>|||(myrights99@.gmail.com) writes:
> I need help to understand how to minimise or completely stop blocking.
> any help, tips or links will be highly appreciated. I have gone thru
> couple of article about blocking but not specified how to stop
> blocking. i will appreciate if some one can give me concept about
> blocking & how it can be stopped. Agian any help will be highly
> appreciated
A very wide topic, and different blocking scenarios requires different
actions.
But generally, make sure that your queries have suitable indexes. Queries
that requires table scans, can be quite obtrusive. It's also good to keep
transactions as short as possible. Particularly, never have a transaction
open while waiting for user input.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx