Hi,
When a query runs on a table and say it takes 10 min to execute. In the meantime some other Job tries to update that table then Update is not happening, may be Tables is locked because select operation is already working.
How can I avoid this. Please help.