Any good references on the nitty gritty differences between #temp tables and variable tables

Hang in there, in a few months you'll be the guru for their systems. Ok, maybe with an alcer or two and the manager will still not know how...

How many calls per sec during expected peak traffic

Potential hotspots on some tables with inserts.

-- Need some more work, maybe function, etc.

Set nocount on

Declare @Job_ID UNIQUEIDENTIFIER

DECLARE @is_sysadmin INT

DECLARE @job_owner sysname

Select @JOB_ID=JOB_ID from sysjobs

Where Name='TEST'

IF NOT (@JOB_ID IS NULL)

...

Just a last stab at the problem.

Can you tried DBCC DROPCLEANBUFFERS, DBCC FREEPROCCACHE to see if it makes any difference before executing the code

One solution is to check if one of the scheduled jobs are running!

Suppose one can also look at all the DBCC INPUTBUFFER for the relevant database and check for the...

If you don't mind me asking, which one did you enhance and what functionality did you add

Use Enterprise Manager and schedule two jobs to perform the insert and clear.

See http://www.sqlservercentral.com/columnists/sjones/identityreset.asp

Remember in the "old" days (6.5) you need to have at least the equivalent of the largest table(bytes wise) free and plus 10% -> 20% before starting to drop and...

Have a look at http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q220/1/63.asp&NoWebContent=1

Have used SCPTXFR.exe myself for awhile!

Alternatively restore full backup as a "new database". Copy last table to live database as a ANotherTable. Restore next differential or log. If data still in original table copy to...

Have a look at Lumigent's

Log Explorer at http://www.lumigent.com/

I think in production environment you'll kill your database. Secondly with multiple tables and a rollback in one all previous captures need to be undone.

IF UPDATE(IsPending) tell you that for at least one of the row(s) the column IsPending was changed.

The part WHERE i.IsPending <> d.isPending check each row to determine for which of...