Not sure how it does it but I don't see anything different under Profiler with or without it on, but I only have one Test BD with a LogFile not...

No, most of it is done using DMO there are examples to do bits and pieces via both DMO and TSQL around here but I have not seen anything to...

Yes but you shouldn't need

SET STATISTICS PROFILE ON

just 

SET SHOWPLAN_TEXT ON

Most likely they created the tables in Model. As all db's built are modeled after model then they of course inherit these tables in their design. Check there and they...

SELECT 

 I.subGroupID,

 I.indicatorID,

 T.taskID,

 SG.subGroupName,

 I.indicatorDescription,

 I.indicatorDescription2,

 I.dataOwner,

 I.dataSource,

 I.dataLocation,

 T.dataValue,

 T.dataVintage,

 T.lastUpdatedDate

FROM

 SubGroup SG

LEFT JOIN

 Indicator I

ON

 SG.subGroupID = I.subGroupID

LEFT JOIN

 Task T

ON

 T.indicatorID = I.indicatorID AND

 ((T.dataVintage BETWEEN @filterdate AND @todate) OR T.dataVintage is null) AND

 (T.eventID =...

When viewed in EM after refreshing the job list does it show NO in the enabled column?

That's weird, your dev execution plan show all table scans and production shows all index seeks. Are you sure these are named correctly? I have neevr heard of a table...

You could try

DECLARE @x INT

SET @x = 1

SET ROWCOUNT 1000

WHILE @x > 0

BEGIN

 BEGIN TRAN

 --DELETE STATEMENT HERE

 SET @x = @@rowcount

 COMMIT TRAN

END 

However with such a large dataset to remove it will still...

Please do not use DBCC DROPCLEANBUFFERS on production as hat will clear the bennifits of all other preran processes and server starts from zero on this.

Instead make sure that you...

If you cannot find aything as stated above then use Profiler to monitor who or what may be triggering the jobs. I have never had a job execute after disabling...

Depending on record size you might want to consider using a temp table for these to ensure less likely to run into especially if the data isn't very large.

As for...

Consider you are doing distinct on you output so by themselves

AccountNumber,

originalBilledAmount,

tbl_PerformedProcedure.PatientPrimaryKey

You get 3252 but when you add in

PhysicianID,

cptcode

You will of course have more potentials for differences should accoutn for that.

If...

Create a black box trace as noted here:

From SQL BOL

-------------------------------------------------------------------------------------

Reporting Errors to Your Primary Support Provider

If you are unable to resolve a problem, contact your primary support provider for assistance....

Create a composite index that contains both ProductName and CatID and using EM set to Unique Constraint.

Or SQL Syntax

ALTER TABLE dbo.tblName ADD CONSTRAINT

 IX_tblName UNIQUE NONCLUSTERED

 (

 ProductName,

 CatID

&nbsp

See this http://support.microsoft.com/default.aspx?scid=kb;en-us;818202&Product=sql2k