I am a complete NUB to SQL Server. I install 2014 Developer on my machine and created a SQL DB from an Access DB using the SQL Server migration assistant for Access.
I created a view in SQL Server Manager to pull matching information for 100k records in one table from a table with 800k records. There should only one or no records in the 800k table matching for each record in the 100K table.
The view is matching records between the two tables using inner joins on 4 fields.
I am trying to run the view from within Management Studio but before it can pull any records I get a timeout message.
I have create and run other views without issue but this one is taking a lot of time to evaluate. Is there a parameter I can specify to give this view more time to evaluate?