I have a number of tables on a SQL Server 2008 database. When I open the tables, the results load right away, but the progress bar indicating that some number of rows were fetched, in some number of seconds, counts on for anywhere from 20 to 70 seconds. The tables have anywhere from 750,000 to 2,500,000 rows. If I click the cancel button the progress stops and the table is usable. The behavior isn't causing any adverse effect on anything, except that nothing can happen with the table until the progress is finished. The time the progress bar runs for would seem to be related to the size of the table. At least in row count. The issue doesn't create any entries in the Error Log.
Any help will be apprecited.
I didn't find the right solution from the Internet.