title: Is there a limit to the number of tables in a SQL Server database AND view?
body: <p>I'm working with a database on SQL Server Standard edition that loads data every day - performance of the <code>SQLBulkInsert</code> is slowing down as the table grows and indexing I/O kicks in (even with disable/rebuild, its getting slower)</p>
  
  <p>So, an alternative suggested to me was to create a view that references each one of the daily tables (or the last 30 for example).  Should just be a case of <code>SELECT * FROM x UNION ALL SELECT * FROM y...</code></p>
  
  <p>Is there a limit to the number of tables that can be included, or the length of the view definition?
  <br/>AND<br/>
  Is there a limit to the number of tables in a database?</p>
  
  <p>OR - is there a better way to do this (without spending any money or I'd move to SQL Server Enterprise and use partitioned tables!)</p>