Joel On Software has an interesting little post about source control and how Microsoft does it (specifically with the Vista codebase).
You can see how it can all get out of control, and how it is easy to find yourself stuck as part of a process that doesn't scale, and how this can adversely effect an entire project. It also shows a lack of modularity since other projects of a large size do not necessarily have similar problems.
