| http://www.w3.org/ns/prov#value | - stead of going to disk, as that IO operation slows things down.it is not like other programs, that give memory back when it is done...it is never done, as far as SQL is concerned.you can limit the amount of memory int eh memory settings under the server properties in the SSMS Object Explorer:
|
