First I know there are dozens if not hundreds of posts on this subject. I have followed all the suggestions; setting the remote execution time out to zero, setting the query
execution time out to zero. Everything I have found I tried some made me wonder if I should of. As my database gets bigger the problem seems to be getting worst. Currently I have around 4 million records. I have normalized the table the best I know how. I
am using SQL Server 2008 r2 express running on a local instance. I am trying to create a view in the View designer. I run the query in query editor it takes just under a minute to run. When I run it in the view designer it times out
in 30 sec. Any help would be greatly appreciated.
Go to the complete details ...