May 30, 2013 at 5:21 am
I have noticed that everytime I commit a large task in SQL Server Management Studio (e.g. the rebuilding of a large table following a field change/new addition), the whole application becomes Unresponsive until the said task is completed. Surely this is unacceptable for a modern piece of software.
This is a general bug that happens irrespective of what machine I am using.
May 30, 2013 at 6:58 am
I'm assuming you are using the GUI table designer to make these changes, which means, since the query is running on the same thread as the GUI it has to wait for the query to complete and on a large table that could take awhile, which means the GUI has to wait. I'd suggest using the Script button and then running the generated script in a query tab which will solve the problem.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 30, 2013 at 7:54 am
Jack, thanks for the tip. It works a treat!
May 30, 2013 at 8:32 am
Have just noticed that while the table rebuild is running in the query window all remaining items in the GUI table designer still seem to become unresponsive. Is there any way around this one?
May 30, 2013 at 8:40 am
So you open the Table Designer, make your change, Script out the change to a new query window, and leave the table designer open?
My best guess would be that it can't do anything because there is a schema lock on the table and in the background it is still doing some kind of query and is being blocked. I'd close the table designer once I had the script.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply