Will performance of a SQL server degrade if the DB can't fit in the memory?
- by Carl Hörberg
Will the performance of a SQL server drastically degrade if the database is bigger than the RAM? Or does only the index have to fit in the memory? I know this is complex, but as a rule of thumb?