as stated in the title
When you connect to SQL Server from an Excel query, the table is
It locks until you exit Excel.
- Only SELECT privileges for connected users
- Application is Mashup Engine
-Queries have relationships and views
I would appreciate it if you know Excel and MS SQL well.
■Additional
Excel queries seem to use the with clause a lot, and
SQL Server appears to have been under load.
Increasing complex relationships and unnecessary processing increases memory load
I think the server side was slow and it felt locked.
The SQL Server default isolation level is READ COMMITTED, so the selected data will be locked.
However, the lock does not always block other Select statements.
You should check if locking is really a problem
If locking is a problem, and if it is possible to change the settings on the server side, snapshot isolation levels may be used.
© 2024 OneMinuteCode. All rights reserved.