Query to fill up RAM

Hi ,
Just need a query which can occupy all available ram for sql server
Thanks
ARRAju 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|||I just need a query which can set fire to a large warehouse full of dirty
socks and then crash the getaway car into a lamp-post on the Garden State
Parkway. Oh and if it can make sparks shoot out of my hard-drive
(asynchronously) that would be a big bonus. :)
Thanks
"Aju" <ajuonline@.yahoo.com> wrote in message
news:eLj3mWmHFHA.2552@.TK2MSFTNGP10.phx.gbl...
> Hi ,
> Just need a query which can occupy all available ram for sql server
> Thanks
> ARR
>|||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:
> > 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
>