Hi,
What OS are you using? MSKB indicates that Win9x can only utilize up to 512Mb of RAM. You'll need NT, W2K, XP to to higher.
HTH,
Arriyel
>I have been given a new machine that has a little over 1 GB of RAM. When running queries on large tables (8 to 10 mil records) with joins, it does not appear to be utilizing all of the RAM.
>
>Any suggestions?
Speak using soft and sweet words in case you have to eat them later.