[dba-SQLServer] Managing orders database

John:  Interesting way of handling it.  It sounds as if all the data is
in one database, and you create new db's that are subsets of that data.
If that is the case, maybe you could have achieved your goal of easy
maintenance by creating a table structure for clients, queries, and
where clauses.  You could save the where clauses in a child table, and
run them, refine (ie add a record with a new where clause), etc. That
way you would have one db with tables with the data, and a few small
tables recording the queries.  Just a thought.  Probably I don't have
all the details of the project, though.  D