Without indexes this has no hope of performing better. Now in my other tests, the indexes were of no help because they slowed the process down signficantly on the...

I should be able to do some tests. I'll start with something like the following.

SELECT @Ctr = 1

WHILE(@Ctr > 0)

BEGIN

;WITH X (RN,StoredCalcDataID,AsOfDate,[Weekly_Type1]) AS (

...

This part of it can vary widely. It will update 100% of the rows that are extracted to the temp table in most cases. The temp table will...

USE [master]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:Bob Fazio

-- Create date: 06/21/2007

-- Description:Function Returns a Date in the form of YYYYMMDDHHMISS

-- =============================================

alter FUNCTION [to_yyyymmddhhmiss]

(

-- Date Time to work with

@theDate...

I'll agree with Matt here. It comes down to what are your entities and attributes here. And it sound like for your needs here are that for your...

Sounds like more homework. Chiko what do you have so far? You have posted the question, but now why you are having trouble with this.

Sounds to me like an exercise (Homework) to show a knowledge of how to write a trigger 😉

Sorry Lowell didn't catch you statement the first time.

Especially considering the...

Also, you named named the procedure sp_ which in has special meaning. Is this in the MASTER database? Is this really what you want?

In general, you do this...

alcohol 52% Free and easy. Share the image, and mount remotely.

RN on base table doesn't work because of Day, Week, Month Gaps. I didn't show it, but I have to run through this 3x to update days, then weeks,...

I work in an office with about 30 people, and I am usually one of the first ones in the office in the morning. I will usually be the...

If blocking becomes an issue, I'll switch READ_COMMITTED_SNAPSHOT on. I have it enabled in most of my databases.

Not sure about read uncommitted as helping, but I could...

Jeff Gray (9/26/2007)

---

If you can rewrite the procedure so that it processes in chunks, you can put a WAITFOR DELAY inside the loop that processes the chunks, and thereby...

Thanks for that, but as I said, this post isn't about tuning the query or the database for that matter. It looks like my only option is the MAXDOP...

I agree that there doesn't appear to be any issues with the SQL.  If this works in T-SQL, then it is probably a code issue.  Are you sure this is...