Michael L John (2/27/2015)

---

A primary key does not have to be a clustered index.

A clustered index does not have to be the...

Matt Miller (#4) (2/27/2015)

---

I am not going to wade in to the main part of the pool (plenty of good advice already out there), but I will point out this...

Michael L John (2/27/2015)

---

See

Grant Fritchey

The Scary DBA

Author of:

SQL Server Query Performance Tuning

and

SQL Server Execution Plans

These...

Thanks again to all! All of you have given me a great deal to think about. 😀

Luis Cazares: Thanks for that! It looks awesome, and I almost understand it, except...

I should have posted this question on a day when I'm not sick. 😀

First of all, thank you all for your advice thus far. I'm sure it will be really...

Nevyn: Depends on what you mean by "a while." The database is fairly small and new, and I think there are less than 200 clients. The Access report that uses...