title: Best optimizing for a large SQL Server table (100-200 Mil records)
body: <p>What are the best options/recommendations and optimizations that can be performed when working with a large SQL Server 2005 table that contains anywhere from 100-200 Million records?</p>