Viewing 15 posts - 16 through 30 (of 76 total)
Dwain,
LOL... after 2hrs, it tossed...
"An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown."
...on a server with 64gb RAM. Last I looked after 30min before...
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
June 30, 2012 at 4:43 pm
Evil Kraig F (6/29/2012)
Wrap this DML in an applock.Basically:
CREATE PROC blah AS
sp_getapplock
Begin Tran
...
End Tran
sp_releaseapplock (or whatever it's called, that's close)
END
Hmmm...no joy. No matter where I put 'sp_getapplock' in the...
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
June 30, 2012 at 2:08 pm
dwain.c (6/30/2012)
You'll...
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
June 30, 2012 at 2:01 pm
G...
Here's the DDL...
USE [CentralServices]
GO
/****** Object: Table [dbo].[CollectorTransitionHistory] Script Date: 06/30/2012 12:24:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CollectorTransitionHistory](
[endpointId] [int] NOT NULL,
[collectorId] [int] NOT NULL,
[dailyReadStartDate] [smalldatetime] NOT...
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
June 30, 2012 at 1:28 pm
>>Do you want to have dup districts? Means can a tupple be like this 'dist1,dist1,dist1' = 300 if dist1 has 100 rows?
No. All old districts must be included, but distinct...
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
June 30, 2012 at 1:05 pm
I believe it's multiple calls, though given the nature, I'm not positive.
I've never used sp_getapplock... but from what I've gleamed, I would copy the DML from this SP to another...
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
June 29, 2012 at 6:17 pm
Thanks Lynn. I'd already checked the index, and added 'SET TRANSACTION ISOLATION LEVEL SERIALIZABLE'. I just posted the original SP code. Still no joy.
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
June 29, 2012 at 5:55 pm
This is a great CTE study for me...
BTW, I ran it against this server, and it ran in 7min...however, no rows were returned.
Singles - you can limit this to just...
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
June 29, 2012 at 9:57 am
dwain.c (6/28/2012)
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
June 28, 2012 at 1:24 pm
dwain.c (6/28/2012)
Since I couldn't stop thinking about this today, I decided to learn what I could so as to ask you my questions prior to the weekend. ...
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
June 28, 2012 at 1:20 pm
dwain.c (6/28/2012)
I did take a quick 15 minute look. It appears you didn't implement Chris's speed improvement suggestions. However I doubt that will be sufficient for the size...
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
June 28, 2012 at 12:32 pm
jeffem (6/28/2012)
We must divide by each combination reduction factor (2! for couples, 3! for...
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
June 28, 2012 at 12:24 pm
Jeff,
jeffem (6/19/2012)
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
June 27, 2012 at 9:47 am
Dwain,
Since #1 is not unique, unless I misunderstood, it shouldn't be included. Only 2, 3, 4 are unique in the set.
~Les
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
June 27, 2012 at 9:10 am
Dwain,
I must be doing something wrong here. I'm using the CTE to attempt the same logic as SW7 to resolve those new Sweden districts with two old districts (doubles), but...
Dr. Les Cardwell, DCS-DSS
Enterprise Data Architect
Central Lincoln PUD
June 27, 2012 at 9:05 am
Viewing 15 posts - 16 through 30 (of 76 total)