Scans vs. Seeks

First published on MSDN on Jun 26, 2006 Scans and seeks are the iterators that SQL Server uses to read data from tables and indexes.  These iterators are among the most fun...