Viewing 15 posts - 1 through 15 (of 76 total)
I am...might as well have it all before I run it up 🙂
I'll send you a paper on MK models via email.
~Les
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
July 12, 2012 at 9:34 am
Ha! I'm glad I could send you on such an adventure 🙂
I'll run both for time comparisons this weekend when there's not much activity on this server (this has been...
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
July 11, 2012 at 9:32 am
I haven't had a chance to come up for air to review the latest, but only 8 unique triplets? I get 162...
I did try to use the CTE in place...
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
July 10, 2012 at 9:43 am
Dwain,
Using your CTE, I've come up with a hybrid solution that shortens my initial code considerably. I'll test over the next day or so and post the findings. I also...
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
July 8, 2012 at 2:06 pm
You're right. It's not in my set either...No clue, other than my mind is also on PTO perhaps :ermm:
AAR, just use the select code from SW6 to get valid sets...
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
July 6, 2012 at 12:08 pm
I haven't walked through the code yet, but...
[33,51,60] - is a triple
[55, 66] - is a double
Triples - I only count 9 in your list. Add the above (33,51,60) and...
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
July 5, 2012 at 11:15 am
Dwain,
My apologies for the mistype on the Population. Fat fingers and all that. :blush:
I think the only thing the CTE is not resolving correctly is those those Candidates where the...
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
July 4, 2012 at 10:29 am
Hi Dwain,
You're getting close.
If you first isolate those districts from Candidates where the Old District only appears once (see SW4.doc), they can then be eliminated from the rest. There are...
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
July 3, 2012 at 11:54 am
Gullimeel (7/2/2012)
Still no luck with plan opening.I am opening it in text pad and data is kidn of scrambled.
Gullimeel...the record locking solved it for now. Thanks again for your insight.
Les
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
July 2, 2012 at 11:01 am
Hi Chris,
>>Just a hunch Les, but have you tried replacing the delete & update with MERGE?
Unfortunately, I can't alter the code. The utility has been replacing in-house developed apps with...
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
July 2, 2012 at 10:58 am
TheSQLGuru (7/2/2012)
I note that deadlock investigations and fixing can be a VERY...
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
July 2, 2012 at 10:50 am
Pffttt...in my overwhelmed state, and attempts at trying various row locking mechanisms, I didn't add EXEC (doh!).
I'll give it a go tomorrow after I see how this latest set...
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
July 1, 2012 at 6:57 pm
Gullimeel (6/30/2012)
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
July 1, 2012 at 12:47 pm
>>Please define 'chokes'. You get an error message?
Msg 102, Level 15, State 1, Procedure UpdEPCollectorAssociation, Line 15
Incorrect syntax near 'sp_getapplock'.
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
July 1, 2012 at 12:22 pm
G...
Looks like the indexes are issues here.
The delete statement is using clustered index but all index keys are not part of it.Thus all the rows which has dailystartdate =@startdate...
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
June 30, 2012 at 4:59 pm
Viewing 15 posts - 1 through 15 (of 76 total)