I have issues with Concurrency.
there has been times when updates happen on my fact table while some users read data from it at the same time, it takes a very long time and there is some blocking issues.
1.My inserts happen as Bulk inserts. I would like to know if I change my query to use NOLOCK will it still be blocked by the Bulk insert when i read? so does Bulk insert do an exclusive lock, so i cant read data?
2. changing my query to use NOLOCK is it benefical?
Please help me
View Complete Post