With that many rows you may also consider 2 more things :

How many rows will be left after the delete? Sometimes it's just faster to figure out the...

You're welcome. So what's the difference in page reads?

GilaMonster (1/18/2010)

---

I have the feeling this is less of a case of it not working on SQL 2008 than it simply isn't supported on SQL 2008. So it might run...

It's s good idea, but usually the ERPs make a ton of use of system objects so that may be why 2008 is not supported at the moment.

no offense but that's still slow as hell.

I have a script that calculates the inventory per location as well as total per item for each of all 900 000 transaction...

Yup, haven't used that one in a while, but that's a perfect exemple of how it could be used.

Of course now with...

I wouldn't even try it.

I'd assume sql server to assume that the system DBs on a sql 2005 instance to be at the 90 level and nothing else.

That's also most...

SELECT List, Of, Columns FROM dbo.Whatever WHERE PostingDate Between @StartDate AND @EndDate

Then you can either add the grouping in the reporting engine (they all do this). Or you can...

Just in case you didn't read the 3 previous correct answers by Gail.

Returned data order is NOT garanteed if you DON'T use order by.

Please add a calculated as checksum or textisvalid(blob image).

add that column in the index of your current query. When the index is created the value will be calculated AND...

Why can't you remove substring? Do you start the search at different places in the column at every run?

Look up for articles on covering indexes on this forum to...

Yes you have persisted columns in sql 2000, they just don't have that name. All you have to do is put the column in an index and it'll persisted...

Thanks, and what's the link on MS?

I've been using sp_startjob for years and since sql 2000. Never had any issues after 3 versions installed on 5 client sites across at least 10 servers... you should...

Try removing the double dot...

OBEAVER.master<one les dot in here>.dbo.sysdatabases'