Roughly, because there's no table def or sample data that I can use to test...

SELECT Odometer, RPTUTCDATE, UnitNumber, MedicNumber

FROM (

SELECT Odometer,

RPTUTCDATE,

...

Why can you not create an index? Are you getting an error? If so what error?

Foreign keys can sometimes help the optimiser to come up with a better plan. The existence of a foreign key constraint gives the optimiser information about the data and that...

It's since the last time SQL Server started.

Not precisely true. Rebuilding indexes will update the stats associated with those indexes, but there's still the...

5000 rows a day is not many inserts, that's extremely low activity. If the index is needed, create it and test impact (in a dev environment)

For those of us who don't have high speed internet, please just the execution plans and indexes, zipped.

Scripts of logins, jobs, etc.

Bear in mind that the master DB has stuff in it specific to the server it was...

To be quite honest, moving the system DBs from one server to another...

It goes back to an index scan because all the key lookups are more expensive than the scan is. A seek is not always the fastest thing and when you...

Yes

Why are you using index hints? Are you really, 100%, absolutely sure that you know better than the query optimiser what index is best for this query with this set...

http://technet.microsoft.com/en-us/library/dd197454%28WS.10%29.aspx

also

http://www.google.com/search?q=clustering+requirements+%22windows+server+2008%22+site%3Atechnet.microsoft.com

Generally nothing.

Locking is a normal part of DB activity and is essential for ensuring data consistency across the database. There's nothing wrong with locks.

Blocking's also normal. Means that one process...

Please post new questions in a new thread rather than hijacking an existing, active thread. Thanks.