Viewing 15 posts - 2,311 through 2,325 (of 8,416 total)
WayneS (12/13/2010)
Did you ever do anything with that missing index on those processes in the c.u.r.s.o.r.? (Or making the CI on BatchGroup?)
I'm not dismissing the idea at all, but I...
December 13, 2010 at 10:02 pm
Craig Farrell (12/13/2010)
It's definately set to true, but that's mostly for the secondary attribute columns...
Ok I'm going to assume that you need NULLs from the input file for reasons I...
December 13, 2010 at 9:58 pm
Craig Farrell (12/13/2010)
December 13, 2010 at 8:20 pm
Craig Farrell (12/13/2010)
As I'm wrapping my head around this, your comment above concerns me. This approach is as valid in 2k5 as well, right?
Yes :laugh:
All things are better in...
December 13, 2010 at 10:02 am
LutzM (12/13/2010)
December 13, 2010 at 9:46 am
Tom.Thomson (12/13/2010)
I'll bet that in the wild they don't have to propagated, they can just replicate themselves. I guess it will be merge replication, rather than transactional. :hehe:
Ouch. I...
December 13, 2010 at 8:56 am
OMG there's a guy called Dr Seward, who has a free eBook called:
I have not yet summoned the courage to hit 'download'...
edit: ok so I can't spell
December 13, 2010 at 12:49 am
You may even find that the partition-switching doesn't speed up the application of the deltas over using a cursor to delete and then insert one PortfolioID/Day combination from the staging...
December 12, 2010 at 7:46 pm
No worries - the basic idea is pretty simple, but it may take a while for all the pieces to fall into place. I'd encourage you to play around...
December 12, 2010 at 7:21 pm
Final demo: converting PortSecAgg into a partitioned table, using fast (minimally-logged) bulk load:
(Converting to a partitioned structure in-place will be glacially slow and blow up your log)
SET ARITHABORT ON
SET CONCAT_NULL_YIELDS_NULL...
December 12, 2010 at 6:19 am
Demonstration of handling a refresh for a particular portfolio for a day:
(uses the same database in the state it was at the end of the last demo)
-- ==========================
-- Demo modifying...
December 12, 2010 at 5:47 am
Demonstration of instant loading for a whole new day of data:
SET ARITHABORT ON
SET CONCAT_NULL_YIELDS_NULL ON
SET QUOTED_IDENTIFIER ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
SET NUMERIC_ROUNDABORT OFF
GO
USE master;
DROP...
December 12, 2010 at 5:31 am
Ok, so those are the problems. The approach I would take solves those problems by not performing all that work at all.
Imagine if the only requirement was to load...
December 12, 2010 at 3:50 am
Hi Craig,
Looking at the execution plans you posted, there are a number of common reasons for the slow performance:
1. Full table scans
2. Large hash joins
3. Large sorts
4....
December 12, 2010 at 3:18 am
Craig,
Thanks for that, it helps a great deal. Just one more question before I get to the good stuff.
The delta/replacement files you get for historical edits: do they contain...
December 11, 2010 at 9:47 pm
Viewing 15 posts - 2,311 through 2,325 (of 8,416 total)