What's a fair price? We're about to find out later today as we have a call with MS themselves 😀 We'll have upwards of 24 procs on 3 machines and...

This is something of a sad...

Makes me think a little of that interview last night on the Colbert Report where he's interviewing this correspondent for the TV show 60 Minutes. She was over in Helmond...

dwilliams-766857 (12/8/2009)

---

Default, by nature, is to help out.

I also use the "I'll do it but then you owe me" routine. I may not take them up on it but it...

nelsonj-902869 (10/15/2009)

---

So if presented with a task that I have no experience with, I go to my library of books, or BOL, or a Help file first, then go to...

And even then it's a bit tricky. Say you're trying to execute 10 T-SQL commands and you get errors on a couple of them. As you say the lines #'s...

Here is the Select statement execution plan attached.

Ken

Yes, this little update is within a larger transaction that does a lot of updates elsewhere in the DB. But it need not be I think.

Begin Tran

Update StartTime

Do many updates...

Update statement is:

Update RollupHistory Set Status = 1, RollUpEndTime = GetDate()

Where CallCenterId = @CallCenterId And RollupSubmissionTime = @RollupSubmissionTime

Indexes are on Status and another on CallcenterId + RollUpSubmissionTime.

Seems like indexes with...

Thanks Matt but it's staring me right in the face. It's The RollupHistory table that's referenced in the view. That table is being updated within a transaction in another proc.

Ken

Andy Lennon (6/30/2009)

---

i'm terrible with documentation. i put descriptions into procedures in a comment block up top and have additional brief descriptions for the business functionality of discrret sections within...

sknox (6/19/2009)

---

Okay, seriously, the personality trait I look for is interest. If my protege has got the interest to want to grow and learn, I would recommend scripting -- and...

Sorry Bruce, Jeff had asked how much data 1 of the procs inside the loop would operate on. That would be thousands. The size of the cursor itself is really...

Thanks for looking at this. I'll take a look at table vars and error handling. These procs operate on anywhere from several hundred rows to a worst case scenario of...

Well, we have an Asp.Net page that queues a row into a table for processing whenever a user makes a change to mapping data for a call center. When they...