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'

Please report this issue on the connect site and post the link back here so other we can vote and follow up on developpement of solutions.

TIA.

Is there any way to run a checksum on blobs?

If so just add a calculated column as checksum. Figure out what checksum of null is then compare to that...

Check out alter database in books online. You can change the size from those command options.

In the GUI you must change the size of the files (free spaces is...