 |
SoftTree Technologies
Technical Support Forums
|
|
| Author |
Message |
neverden
Joined: 02 Dec 2008
Posts: 58
|
|
 Performance Issue with XML |
 |
SSMS 2008 becomes unusable if I have a result that contains XML. I have to disable SQL Assistant. I have syntax and spell checking disabled.
|
|
| Tue Jun 08, 2010 1:02 pm |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
Would you please explain what you mean by "unsuable?"
What does retrieving XML results using SSMS have to do with SQL Assistant?
|
|
| Tue Jun 08, 2010 7:01 pm |
|
|
neverden
Joined: 02 Dec 2008
Posts: 58
|
|
| |
|
Unresponsive, slow, typing faster than the text will display.
idk what it has to do with SQL Assistant but if I disable SQL Assistant SSMS starts working correctly. I assume its parsing the large xml results (execution plans) or something
|
|
| Tue Jun 08, 2010 7:18 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
Do you mean typing in XML window or typing in SQL editor window?
Which version of SQL Assistant is that?
|
|
| Tue Jun 08, 2010 7:24 pm |
|
|
neverden
Joined: 02 Dec 2008
Posts: 58
|
|
| |
|
I am using 5.0 the latest build. I am selecting columns that are of type XML. If you click on these it opens the XML in a window.
I mean typing in the SQL editor. Everything is slow. Even if I am typing standard t-sql.
|
|
| Tue Jun 08, 2010 7:34 pm |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
