title: SQL Hint to load entire table into RAM before execution?
body: <p>I'm running some aggregation queries on some very large tables in an OLAP environment. I'm currently bottlenecked by disk IO at 200 MB/s.</p>
  
  <p>I'm doing these queries on a machine with 92 GB of RAM. Is there any SQL hint I can write into my query that basically tells SQL to load the entire table into RAM before execution?</p>
  
  <p>Something like:</p>
  
  <p>select * from myTable with (ramdisk)</p>
  
  <p>I am using MS TSQL.</p>