Great Topic, wrote on this last year (and should update it too): http://www.sqlservercentral.com/blogs/hugo/archive/2009/07/06/object-grouping-best-practices-using-schemas-for-logical-separation.aspx

Love Oracle, and whenever I hear the argument that MSSQL is cheaper because it is easier to manage more databases...I can't help but scream you are comparing Apples and Oranges. Simply cannot compare the two, because Oracle prod installations use Schemas way, way, more than in SQL Server. In corporate environments this started changing a load last year, within the several groups I worked with.

Thanks Phil, for pointing this great database organisational tool out in the newsletter.

1506 Pauline-Julien

Montreal, QC H2J 4E4

Mobile: (514) 812-5087

http://Intellabase.com

hugo@intellabase.com

SQL Server Most Valuable Professional 2010

Simple-Talk.com Technical Author

http://www.simple-talk.com/author/hugo-shebbeare/

SQL Server Central (weekly) Blogger

http://www.sqlservercentral.com/blogs/hugo/