Query to fill up RAM

Hi ,
Just need a query which can occupy all available ram for sql server
Thanks
ARR
Aju wrote:
> Hi ,
> Just need a query which can occupy all available ram for sql server
> Thanks
> ARR
If you want to use memory and not too much CPU, just issue from SELECT
statements from your largest tables. Or you could reference a few tables
in a SELECT and leave off the join:
Select * from sysobjects a, sysobjects b, sysobjects c
What exactly are you trying to accomplish with this task?
David Gugick
Imceda Software
www.imceda.com
|||Thanks
Just testing an application . Wanted to do it quickly .
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23$FFFKnHFHA.1396@.TK2MSFTNGP10.phx.gbl...
> Aju wrote:
> If you want to use memory and not too much CPU, just issue from SELECT
> statements from your largest tables. Or you could reference a few tables
> in a SELECT and leave off the join:
> Select * from sysobjects a, sysobjects b, sysobjects c
> What exactly are you trying to accomplish with this task?
> --
> David Gugick
> Imceda Software
> www.imceda.com
>