|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server Management Studio slow at opening tablesHi, I am running SQL Server Management Studio on a dell inspiron 9300 with
an ATI Mobility Radeon x300 graphics adapter. So far so good, but there is one particular function in the GUI that don't work as expected with the screen resolution set to anything higher than 1440x900. When I right-click a table (even a table containg almost no data) and select "Open table" the results take a long time (5-10 seconds) to display properly, unless the screen resolution is set to 1440x900 or less. Has anybody had similar experiences? I've installed SP1 with no changes detected. Executing a query like Select * from tablename returns results in an expected manner (no delays due to akward paneupdate). Torkjel I have not tried to even run SSMS on a resolution that high as of yet so I
can't say one way or the other. But that is a bad practice in general and I would advise using the Query Editor instead for all queries. It is a much safer and cleaner approach, especially on a production server. -- Show quoteAndrew J. Kelly SQL MVP "Torkjel Ingebrigtsen" <trk***@frisurf.no> wrote in message news:KvednUM-2ujRr2bZnZ2dnUVZ_76dnZ2d@telenor.com... > Hi, I am running SQL Server Management Studio on a dell inspiron 9300 with > an ATI Mobility Radeon x300 graphics adapter. So far so good, but there is > one particular function in the GUI that don't work as expected with the > screen resolution set to anything higher than 1440x900. When I right-click > a table (even a table containg almost no data) and select "Open table" the > results take a long time (5-10 seconds) to display properly, unless the > screen resolution is set to 1440x900 or less. Has anybody had similar > experiences? I've installed SP1 with no changes detected. > > Executing a query like Select * from tablename returns results in an > expected manner (no delays due to akward paneupdate). > > > Torkjel > > Torkjel Ingebrigtsen (trk***@frisurf.no) writes:
> Hi, I am running SQL Server Management Studio on a dell inspiron 9300 I have no problems with Open Table on my workstation where I run> with an ATI Mobility Radeon x300 graphics adapter. So far so good, but > there is one particular function in the GUI that don't work as expected > with the screen resolution set to anything higher than 1440x900. When I > right-click a table (even a table containg almost no data) and select > "Open table" the results take a long time (5-10 seconds) to display > properly, unless the screen resolution is set to 1440x900 or less. Has > anybody had similar experiences? with 1600*1200. However, during the beta programme, I had SQL 2005 on virtual machines only, and on the VMware machines, the grid in Open takes an absurd long time to draw. Just like Andrew, I prefer to stay away from Open Table, and my this my recommendation to everyone else. In the long run, you are far better of with running queries. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx Thank you both for your replies. I agree that the 'open table' function is
of little interest and maybe is even left best alone most of the time, in a production environment. But some obvious flaws are harder not to persue than others, this one espescially so as it was so easily at hand when trying out the 'SQL express' vesion of SQL server 2005. I couldn't quite decide wether it was an application issue or maybe a driver issue. Torkjel Show quote "Erland Sommarskog" <esq***@sommarskog.se> skrev i melding news:Xns9834ED6DB932AYazorman@127.0.0.1... > Torkjel Ingebrigtsen (trk***@frisurf.no) writes: >> Hi, I am running SQL Server Management Studio on a dell inspiron 9300 >> with an ATI Mobility Radeon x300 graphics adapter. So far so good, but >> there is one particular function in the GUI that don't work as expected >> with the screen resolution set to anything higher than 1440x900. When I >> right-click a table (even a table containg almost no data) and select >> "Open table" the results take a long time (5-10 seconds) to display >> properly, unless the screen resolution is set to 1440x900 or less. Has >> anybody had similar experiences? > > I have no problems with Open Table on my workstation where I run > with 1600*1200. > > However, during the beta programme, I had SQL 2005 on virtual machines > only, and on the VMware machines, the grid in Open takes an absurd long > time to draw. > > Just like Andrew, I prefer to stay away from Open Table, and my this > my recommendation to everyone else. In the long run, you are far better > of with running queries. > > > -- > Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se > > Books Online for SQL Server 2005 at > http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx > Books Online for SQL Server 2000 at > http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx  
Other interesting topics
|
|||||||||||||||||||||||
