Query Would Run For Ever - No Clue

Hello fellow DBAs

I have a strange situation here. I am executing a SQL query which runs for ever till it fills up all the available temp space.

The same query runs within 1 minute in another database on another server. That database is a development database but with same records (and data).

I tried the following:

UPDATE STATISTICS
DBREINDEX
FIXED FRAGMENTATION BY RUNNING DBINDEXDEFRAG

Nothing helps... what should I do next?post the ddl + the query so we can see. Its common to have a rogue/running away query that would take the server down to its knee.

e.g.
select *
from master..syscolumns,master..syscolumns,master..sysc olumns,master..syscolumns

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
>

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|||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
>

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
>