I would like a tool that predict the overall benefit to a system of an improvement of a constituent part.

I've read a piece on queue theory which used the example...

I have a huge parent/child schema which has to be partially flushed out every night so deletes for me are a major issue hence why I don't use DRI.

On a...

See BOL for sp_addlogin example E.

Basically create you Informix login on your new box so that it is identical to the Informix login on your old box.

I believe that there is a "Lock Pages In Memory" policy setting that needs to be applied to the service account. This is not enabled by default even for...

Tulasoft SQL Examiner is a pretty good tool and it is relatively cheap.

What I have seen of Apex tools impresses me, but be warned they are like drugs. ...

Cascading deletes are an absolute nightmare!

Let us suppose you accidentally attempt to delete a parent object (shouldn't happen but we are talking about the real world here). DRI will...

Has your database been backed up to append(rather than overwrite) the backup to a previous backup file?

Float is an approximate datatype so you can get some unusual values for seemingly simple maths.

Decimal and Numeric are precise values.

If you want to reset an identity range then

DBCC CHECKIDENT('YourTable',RESEED,0)

If you want to explicitly add a record that over rides the identity then

SET IDENTITY_INSERT dbo.YourTable ON

INSERT Yourtable(PKField,OtherFields) VALUES (0,Yourvalues)

SET IDENTITY_INSERT...

If all you want is a rowcount and you are prepared to put up with an estimate then set up your function to pass in the name of your table...

I've got both SQL2000 and SQL2005 on my box at work without any problems.

I don't think it will be SQL2005 that hosed EM because SQL2005 does not use MMC.

OK my eventual solution (which probably isn't the best) was to have my begin loop code enable/disable the relevant steps but store the number of steps in a global variable.

At...

Yes I did mean "This doesn't".

In both SQL 2000 and SQL 2005 the statement forces an index seek however in SQL2005 a "Filter" step is added into the execution plan...

Don't do it as a trigger, do it as a stored procedure and schedule it for 1st July and 1st Jan.

From previous posts the native defragger is a cut down version of Diskeeper.

If your files are across a RAID array or a SAN then be careful with your chosen defrag...