With SQL Server, as with most software development, there are multiple solutions to any given problem. Some of these solutions are acceptable, some are worse than the problem they are attempting to resolve, and some, the rare few, have been proven over time to be the best performing and most maintainable. These are the solutions we highlight. As SQL Server consultants practicing at multiple customer sites over the last decade we’ve seen the worst of the worst and helped implement the best of the best. Our goal is always top performance with ease of maintenance, creating an MS SQL environment which can scale to your hardware and your development team’s maximum potential.