yep checked for all those....doesn't seem to be waiting on anything..

and this prod server isn't heavily used...

I also tried

while (1=1)

select waitime,waittype,lastwaittype from sysprocesses where SPID=<the query SPID> where waittime...

Yeah sorry....the execution plans are identical on both stage and production...

but return times are 2 seconds on stage....3minutes in prod.

Didn't think about using plan guides....

I'll read up on it..

I have the plan from the stage server..can I force the prod server to use that plan?

Although the plans appear...

already used with recompile...no luck

can't drop cause it's in use..

I created a new proc (myproc_2) which was a copy of the existing query and then ran against that...still slow...

any other...

I re-complied but slowness still exists..

We are gonna try bouncing the server this weekend.

yeah it helps thank you..

okay so I followed your advise ...ran the execution plan on both prod and stage boxes..

On my prod box (query 4) I have a clustered index scan..cost of 81 percent

I...

the execution plans appear to be the same...

Thank you!

it is not on backorder?

anyone actually have a real dev edition?

It was permissions!

Thanks guys!

Good karma to you all..

yeah everythings the same I can see all the old DB's in the catalog

just not the new DB I just created.

I waited for the server to get out of recovery..which it did..

But when I expand on anything I get the "lockout time out period exceeded" error 1222

I tried changing the...

Thanks MAN!

how would i update this column?

update upb set upb = /100