title: View with NOEXPAND stop expandation
body: <p>I have a large database and for one of the table I want to create a noexpand view, that will filter some of the records from the table - from 10 000 000 records must show only 100 000 but the execution of the creation for the view last more than 10 minutes and the view is not created.</p>
  
  <p>How could I make the view to be populated in background of SQL or make the script execute on more than 10 minutes?</p>
  
  <p>The SQL Server is located on other machine, and I have only admin access for SQL not on machine to modify machine.config.</p>