[dba-SQLServer] Query Analyzer hogs machine

Send me a sample (or the entire) db and the query, and I will investigate what happens on my box. The only way (without evidence) that I can see this happening is that your indexes are out of whack and that you're forcing table-scans. Even then, it shouldn't consume so many resources.

Arthur

----- Original Message ----
From: JWColby <jwcolby at colbyconsulting.com>
To: dba-sqlserver at databaseadvisors.com
Sent: Sunday, November 26, 2006 9:35:18 AM
Subject: Re: [dba-SQLServer] Query Analyzer hogs machine

LOL.  This is a server in my home office.  

Seriously though, if I must (and it appears that I must), then I must.  

Cheap it ain't though.  I spent well over 3K of my own money for this
machine.  Unlike others perhaps, I do not have a big company handing me a
budget for hardware.