title: dynamic sql performance and implementation recs?
body: <p>I'm working on a new service that will need to provide reporting data for regions. Each region will have its own db table and each db table will have some columns with the same name like ReportDate. The different tables will have a lot of different/unique columns which is why I created a separate table for each region. There will be about 10 region tables.</p>
  
  <p>I'm considering using dynamic sql for my sproc so I can write a simple query and then run it generically against each table. This would be much quicker and easier to write and maintain then writing 10 separate queries that perform the same SQL against all tables.</p>
  
  <p>Is SS pretty well optimized to handle this type of implementation? Do you see any potential performance issues? Are there any specific steps I should take to optimize performance for this implmentation?  Does anyone here think dynamic sql is "evil" for one reason or another?  I'm referring specifically to dynamic sql completely done within SS as opposed to an external app passing in dynamic sql statements.</p>