Steve Jones - SSC Editor (8/31/2015)

---

What code did you run?

What I find is that tempdb is hard, because there's usually a load in it. I'd shrink files, not the...

.Jeff,

I'm not sure how to change the code?

Thanks again.

left JOIN ContractorCoverageException cce ON cce.contractorcoverageID = a.ID and cce.PostalID = postal.ID and e.postalid is null

-- and not exists (select postalid...

Jeff Moden (8/28/2015)

---

Welsh Corgi (8/28/2015)

---

I have the following code that includes a Not exist and when I run it takes 4 minutes. If I exclude it take 40 seconds to...

Before I read the replies I replaced the not exist with a left join.

It takes 5 minutes either way.

Thank you.

left JOIN ContractorCoverageException cce ON cce.contractorcoverageID = a.ID and cce.PostalID...

ok, I will resolve the problem myself.

No need for additional post.

Thank you.

All that I want to do is remove the not exist and delete from the Temp table.

Thank you.

I updated the statistics and the execution time dropped...

The executions are relatively the same.

It takes a minute and 19 seconds or the Published and 5 and a half minutes on the Subscriber.

Eric M Russell (8/25/2015)

---

The following query will return for each statement in a stored procedure:

execution plan, elapsed time, worker time (CPU), wait time (in blocked state), local reads, physical...

John Mitchell-245523 (8/25/2015)

---

Here are the first two things I would look at:

(1) Is your query being blocked by another process?

(2) Have you compared the execution plans from the two databases?

Are...

Vladan (8/25/2015)

---

Hello,

any time you move the procedure into different environment, its performance may change - sometimes significantly. I have absolutely no idea what the procedure is doing, how large are...

Lynn Pettis (8/19/2015)

---

I could the see the problem from the git go:

DECLARE @TableName VARCHAR (50)

DECLARE @BatchSize int

DECLARE @ArchiveYear Date

DECLARE @RowCount int

SET @TableName = 'tblCall'

SET @BatchSize = (SELECT BatchSize FROM PrismDataArchive.dbo.ArchiveDriver...

Thanks.

I changed this:

WHILE @BatchSize > 0 AND @TableName = ('tblCall') AND @Active_Indicator = 1

To this. It works.

WHILE @BatchSize > 0 AND @TableName = 'tblCall' AND @Active_Indicator...

The @Active_Indicator Variable is being set to 1 now but it does not execute the WHILE Loop.

That does not make sense?