Thanks for the quick response!

Definitely option 3 is a semi denormalized option but would you agree it is the best performer in terms of SELECTs? In fact, I'm sure it...

Thank you Grant. That helps clarify things for me!

Good call. We noticed that after I posted this and it worked. You were right on the money though. Thanks!

Our purpose for knowing when an index was reindexed was to ensure that our maintenance jobs are running properly and consistently. I know you can get the last time that...

As long as we are on the topic of lookup tables, here is a performance questions related to them. Take the situation where an application has a known and unchanging...