I have a SQL view that grabs data from various tables. One of those tables is table Y. The view is kinda slow and while the view is running I am unable to run any update statements on table Y. So I ran a stored procedure to view the current locks on the SQL server while the view is running. There was an IX lock on table Y. Now this view is only used to "View" data; why would the SQL server lock that table while it's running? Is there anything I can do to prevent this from happening? :/
-
Follow
Oops, something didn't work.
Sign In to be begin to follow this thread
What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in. You need to be signed in to Channel 9 to use this feature.Getting "follow" information
Start following this thread
What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in and view them all on your notifications page.Removing your "follow"
Setting up your "follow"
Did you know you can
sign up for email notifications?
Thread Closed
This thread is kinda stale and has been closed but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.