I'm not sure if it's possible for SE folks to disclose architectural details, but I'm very curious about what happens in the backend when a new SE site is created. Is there one big database that holds all of the SE site data, with all Questions being stored in a single table, and perhaps a table of Sites that gets linked to relevant content? Or is it more complex than that?
Update: I've spent the past week learning about multi-tenancy, and I'm even more curious about this now. On my app, I implemented a Tenants table, and every non-constant model has a FK of TenantId. This keeps the app in a single app pool with a single database.
So, asked another way:
How does SO do it, in the context of SE sites, and enterprise clients?