Very Computer

by **Yee** » Tue, 02 Apr 2002 11:06:34

Hi,
I have a problem locking a table when the deletion is
doing on that particular table.
I am using SQL command to do the deletion by using clause
DELETE....WHERE....
This is a multi-tasking enovironment where the record
updating is doing into a SQL table(the server is nonstop
running to get the life data). Meantime, there is another
process for the table housekeeping when the time the
traffic is not so busy to do the updating into that server.
I found that the table is lock when the deletion process
is running, cause the record cannot be successful updated
into the table.
Is there anyone can help me to solve this problem.

Thanks.

by **Bob Pfeiff [MS** » Tue, 02 Apr 2002 23:33:34

How many rows does the DELETE affect? A table lock might be acquired if the
DELETE affects a large percentage of rows in the table or if the DELETE has
to to a table scan . It might help to create an index on the column in the
DELETE statement's WHERE clause if you don't have one.

Look at the execution plan of the DELETE statement in Query Analyzer to get
a better idea of what is happening.

--
Bob
Microsoft Consulting Services
------
This posting is provided AS IS with no warranties, and confers no rights.

by **yan wang [M** » Fri, 05 Apr 2002 11:35:53

Hi,
If blocking always occurred , you may check your client AP and see if any
way to optimize it.

Regards,
Yan
***This posting is provided 'AS IS' with no warranties, and confers no
rights.*****

Very Computer

Locking table when deletion is make

Locking table when deletion is make

Locking table when deletion is make

Locking table when deletion is make