Greetings gurus,
This is my first time here and I am glad to be here.
I have been having this major issue now for over a week and I have not come
close to solving it.

Have i have a prob i hope some one will assit me
the below query running slow on 1 maching takes 3 min and on other server
runs in 2 sec.columns and indexes both are same on that 2 servers .the
problem started recently...

Here's a good one for you.
First of all we are talking about a SQL Server 2000 Standard installation.
We have just recreated a database from scratch in order to eliminate
internal defragmentation at a customer site. The system is highly

We host a series of databases (SQL Server 2000 sp4) for customers; they are
all of identical schema.  Recently, one of them became extremely slow.  We
tried to find out what was wrong, but couldn't.  I'll give you a quick
account of what we did in the hope that you might be able ...

I have been reading through the other thread in this group on execution
plans but need some input on next steps for resolving my own execution plan
issue.
I am running MS SQL Server 2005 - 9.00.1399.06, x64, Standard Edition

I run a job with dbcc shrinkfile('filename').  This job runs a long time.
While the job is running, I check EM's Current Activity and find one process
is executing the job step of DBCC. I see this process is blocked by its own
processid; with wait type of PAGEIOLATCH_EX.  The ...