Software Stack: http://blog.stackoverflow.com/2008/09/what-was-stack-overflow-built-with/
Database Details: http://blog.stackoverflow.com/2009/06/stack-overflow-creative-commons-data-dump/
What are the details of the Stack Overflow development architecture. Things such as schemas and queries related to how they handle tagging, caching of various parts of the page, how the database is configured to handle greater number of reads to writes (or vice versa if it's write heavy).
If these can't be answered directly regarding the exact implementation, then answers or discussion on how you would implement the different aspects of the site would be great, or Best Practices regarding how to implement a site similar to this. Also, maybe a collection of the links to the posts that describe an aspect of the site design.
- SQL Server Configuration
I have updated the question to make it more clear what I was looking for. TheTXI answered with a link to the different technologies and info on the what the software stack consists of.
If you still think this is a duplicate or irrelevant question, please edit it or remove it.