My Most Embarrassing SQL Moment
Bert Wagner
31

You might want to ask that DBA why their precious production server only has 10 GB of RAM. The OS takes 4 GB all by it self. If that database has tables with 1+ billion rows it will never fit into memory. The indexes alone would be over 10 GB. Get more RAM.