• I don't use schemas everywhere for the sake of just using them but I DO use them and they are fantastic!  I have a datawarehouse that contains data from several different locations.  Who can have access to all this data can be very messy.  This is where schemas come in, I create few logical schemas with their own database role that has appropriate permissions to that schema (the schemas in this scenario only contain views and procs).  I then add AD groups to the correct role and done.  Setup is probably the worst part but after that managment is so easy.

    EDIT: Another time I use schemas is during data load for table switching.  It's easy to keep the names of the table the same.  I use load schema that is swaped in to the final table when the load and other processing is complete.


    SELECT quote FROM brain WHERE original = 1
    0 rows returned