My SQL Server Machine has 6GB of RAM but the database size is 20GB. The Database is mainly an events log, clustered-indexed by time.
The clients are mostly interested in the latest data. They want it to be super fast when querying these latest data.
As SQL Server loads itself into server memory, is there a way to instruct SQL to pre-load only the latest data into memory?