increase Ram?

i have DB 2GB on disk.
if i increase tha ram up to 4GB, the sql sever use with the
ram to his temporary table while process quiry?Hi

SQL 6.5 had an option to load tempdb in RAM but this is not available in
newer versions. In the later versions you can pin tables in memory but if
your table is temporary it would not be a candidate for this as small static
tables are more suitable for this option.

The ability to use more than 2GB of memory is dependent on the version of
SQL Server you are running and the version of Windows it is being run on. To
enable more than 2GB memory check out:
http://msdn.microsoft.com/library/d..._ar_sa_6b3k.asp

http://msdn.microsoft.com/library/d...server_1fnd.asp

John

"Mtcc" <m> wrote in message news:3fbdf127$1@.news.012.net.il...
> i have DB 2GB on disk.
> if i increase tha ram up to 4GB, the sql sever use with the
> ram to his temporary table while process quiry?