Great question, Steve! 🙂

Looks like a simple select * from Table1 where InvoiceDate between '8/1/2005' and '8/12/2005' does NOT use the InvoiceDate index (it uses the PK clustered index, as...