• DinoRS - Thursday, November 15, 2018 1:00 AM

    I like to use Custom Schemas for segregation of applications or application functions. One thing I like is using an [Error] Schema in DWH Scenarios, there I have things of interest like certain tables might need correction when lookups fail, you want to know which rows failed so you have a [Error]LKP_TblName table in there, of course the naming schema might look different if the DWH serves multiple smaller applications.

    It makes Filegroup Partitioning much easier, too if you have sensible ETL Schemas for each step of the process which helps you avoid file contention when data from one stage is being loaded or processed into the next stage.
    Some might argue I look way too much at details but I like details like these, they make my designs quite fly with the right hardware beneath.

    I hadn't thought of using an Error schema before.  I will keep that in mind for future projects.  Thanks for sharing.

    Ben