I strongly recommend you do not go that design path. It's possible, it's not going to be fun and honestly it's not that good of an idea.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability