I dont think Lock pages in memory is the answer, especially because of this.

http://msdn.microsoft.com/en-us/library/ms190730.aspx

Lock pages in memory is available for standard edition as of SQL Server 2005 SP3...

I think it'd be doing a disservice to the people responsible to try to lump in requirements gather and design into a discussion about database design. Ultimately, I think...

My opinion says that yeah, this was a meant to be spot the flaw in the design (hence the title). Understandably, you could say flaw #1 are the requirements...

dave.baldwin (11/20/2007)

---

I find it puzzling to have the reviewdate be the clustered index. This seems like an unlikely column for a query. Wouldn't it make more sense to...