Chrissy321 (2/11/2013)
I have never been a tbl-er but I have been a usp-er.Lately I put everything in a schema. Is this a reasonable statement as far as a best practice? Always put all objects in a schema besides dbo.
Educational comments most welcome....
It depends.
If I have discrete sets of functionality, then I break things up into schemas. But it needs to be substantial. I've never created a schema for 2 or 3 tables alone. If there really isn't any way to differentiate the parts of an application or if the application is small, then I just leave it in dbo. Since schema ownership can make things easier to manage, I find it helpful for big databases.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning