My rule of thumb is to break it out as follows(minimum) as a starting point

Data

Indexes for Data

Read Only Data

Indexes for Read Only Data

"Read Only" can encompass seldom updated data as...

Phil Factor (5/8/2010)

I agree. I find the object browser puzzling...

I use them a LOT. Especially for applications (SaaS, CRM's and so on) where I have a Global set of tables, etc... that all my end users need. ...

You should look at using derived tables.

(i.e. Select MyField from MyTable m1 inner join (select keyfrom MyTable where blah) m2 on m1.Key=m2.Key)

What I've done in the past was to Create an update query that takes the same select criteria as the export query. I set the export query in one ExecuteSQl...