affinity mask-2147483648214748364700

allow updates0100

awe enabled0100

c2 audit mode0100

cost threshold for parallelism03276755

cursor threshold-12147483647-1-1

default full-text language0214748364710331033

default language0999900

fill factor (%)010000

index create memory (KB)704214748364700

lightweight pooling0100

locks5000214748364700

max degree of parallelism03200

max server memory (MB)4214748364721474836472147483647

max text repl size (B)021474836476553665536

max worker...

i'll put that table into it's own database and zip it up for everyone to take a look at, the data in that table doesn't have to be secure

Will do...

The only other thing on the box is cold fusion and IIS 5, which is hosting a smallish site (the larger site is on it's own box and uses this...

There's a fair amount of load on the production server, but the cpu averages at 6%

Both boxes are just default sql installs, nothing special has been done, they both use...

ok, here we go

production:

SQL:StmtCompleted

Duration 242

CPU0

Reads 53

Writes 0

development:

SQL:StmtCompleted

Duration 80

CPU 0

Reads 53

Writes 0

i'm accessing both from home so i don't know if that'll make a difference (dev box is in the office,...

here's the results of what Antares686 suggested i do, they're exactly the same

SET SHOWPLAN_TEXT ON

GO

SELECT *

FROM [237_1]

WHERE parentid < 1

AND status <> 2

AND active = 1

AND...

I couldn't do a direct upgrade from 7 -> 2k, i had some problems, so i uninstalled the mess that the installer left and installed 2k from scratch

The database in...

i hope this is what you mean:

development (the one that works):

CREATE TABLE [237_1] (

[pageid] [int] IDENTITY (1000, 1) NOT NULL ,

[HTMLtext] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[languageid] [int] NOT NULL CONSTRAINT...

ok, i decided it was about time to upgrade the hosting box to sql2k sp2, so that's what i've just spent the last 2 hours doing *sigh*

Although it has helped...

When i run the query on the SQL 7 box in QA it says that it's missing the statistics for this table and to right click on it, and choose...