Designing for Performance: Lookup TablesCommented on: 7 years ago
(September 19, 2006)
Disagree with "hotspot" theory. A small lookup table is most likely to be memory cached.
Disagree with Denormalization hype. Its not as if 100% of all datbase tables are fully normalised in practice...
When DBAs and SysAdmins learn the ins-and-outs of AlwaysOn Availability Groups, they’re then able to address high availability and disaster recovery concerns from a single interface or set of tooling, thus providing better scalability of management....More