This article is half-done without your Comment! *** Please share your thoughts via Comment ***
Are you database developer?
Are you looking for a job change or preparing for next interview?
Then, You must know about the Database/Table lock related questions/practical solutions.
SELECT *FROM Table_Name WITH (TABLOCK)
VS
SELECT *FROM Table_Name WITH (TABLOCKX)
Sort answers like:
TABLOCK means a shared lock (You can select the data anytime)
TABLOCKX means an exclusive lock (You can’t access the table until it finishes the execution)
TABLOCK is used for operations that do not change the data
TABLOCKX is used for the data modification operations
Leave a Reply