Does Microsoft's SQL 2005 use Rushmore technology?

If I have two indexes on two different fields in a table and perform a SELECT query on those two fields, will the server use the indexes automatically (in an optimized / fast search) or will it perform like the LOCATE command without rushmore, and search through the entire database on the server?

Do I have to be explicit with the index usage when performing a query or is it all taken care of by the server provided I have the indexes in place?

Thank you in advance.