Database is purchased for SQL2019 Standard Edition 5. Will the user be associated with this one?
select * from UDT_S_8494 where UDF_S_15736 ='CGA0189'
The command can be executed normally Data is 22 takes 0 or 1 seconds(feels a bit slow) < br / > select * from UDT_S_8494 article is more than 6400 records of the remote VPN connection database
But when executing the delete statement, the data to be deleted is 22 points into the deadlock can not complete execution, I do not know why, if avoid this situation.
delete from UDT_S_8494 where UDF_S_15736 ='CGA0189'
0 Answer
Database is purchased for SQL2019 Standard Edition 5. Will the user be associated with this one?
the reference answer GPT ᴼ ᴾ ᴱ ᴺ ᴬ ᴵ < br / > the table lock, there may be other session is occupied or cause you can't delete records. If you have permission, you can try to execute a lock command on this table to prevent other sessions from occupying the table and to try to delete records. Alternatively, you can try copying the table locally and running delete statements locally for better performance and reliability, or tuning your database connection or server configuration to improve performance. If none of these solutions solve the problem, you can contact your database administrator or technical support for more help.
这家伙很懒,什么都没留下...