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”?