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...

Don't all indexes hang of the clustered index?

If you rebuild a non-clustered index and then rebuild the clustered index doesn't that alter the first index?

I have noticed that DBCC UPDATEUSAGE(0)...

Have you asked the job to notify you on success.

I had a situation where I got SQLMail to email me on successful completion. Something went pear shaped on the...

If an attempt is made to insert a value in a table with an identity value and it fails the identity value still increments.

I would run a SQL Profiler to...