Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
grnst
Starting Member
1 Post |
 Posted - 2010-07-27 : 03:51:23
|
| I have a fast dedicated server (2008 64bit) with mssql 2008 hosted by my provider on the internet. I create a database with SSMS on the server itself with 1 empty table, with 1 row. When I right click this table and use: “Edit Top 200 Rows” it shows this empty table directly.When I login from my local computer and connect using SSMS and do also “Edit Top 200 Rows”, it first wait for 6 seconds and then shows the table data.Just for testing did the same witch a table with 5000 rows. Also the same thing happens. When I do a “Select Top 1000 rows”, it shows within 1 second, so the server and its connection looks fine.Question: What can do to speed up this “Edit Top 200 Rows”?(I did already a server re-install, tried connecting from different client computers, tested with full and empty databases, e.d. but still the same problem) |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-07-28 : 10:57:57
|
| you should be writing T-SQL statements, not editing that way |
 |
|
|
|
|
|
slow Edit Top 200 Rows in SSMS