http://msdn.microsoft.com/en-us/library/aa479086.aspx
I get questions like this a lot from people starting out designing their SaaS app. It came up again tonight so I thought we’d make a new category on here for Useful Links and I’d post this one up.
It’s the best overview of the primary options for multi-tenant database layouts that I’ve seen.