Viewing 15 posts - 16 through 30 (of 162 total)
The other option I was thinking about was a factless fact table with effective dates
September 10, 2013 at 3:12 pm
Thanks for your time on this. The conclusion I kept coming to was two fact tables as well.
What did you think about the mini dimension solution for those more frequently...
August 8, 2013 at 8:19 am
Apologies! My mistake sorry.
It should total the 100. Updated code attached:
declare @policy table
(policy_number int)
insert into @policy
select 100
union
select 101
union
select 102
declare @policy_risk table
(policy_number int,
risk_type int,
premium_class char(3))
insert into @policy_risk
select 100,...
August 8, 2013 at 6:56 am
Ok thanks for your help:
declare @policy table
(policy_number int)
insert into @policy
select 100
union
select 101
union
select 102
declare @policy_risk table
(policy_number int,
risk_type int,
premium_class char(3))
insert into @policy_risk
select 100, 1, 'AA1'
union
select 100, 1, 'ACC'
union
select 100,...
August 8, 2013 at 6:01 am
Hi Both,
Thanks for your replies...I'll provide a little more detail based on your response.
Source system has the following tables:
Policy table (a record for each policy)
Policy risk (a record...
August 8, 2013 at 5:17 am
Ok so monitoring is a separate issue here.
The Redgate procs will attempt to apply the log files in the 'ToBeProcessed' folder and move them to a 'Restored' folder as...
September 20, 2012 at 8:23 am
In other words this log shipping process is not controlled by Redgate SQL Backup!
September 20, 2012 at 4:38 am
This is what I mean by custom:
We have Redgate SQL backup product installed on both servers.
There is no direct connection permitted between the primary and secondary servers so we...
September 20, 2012 at 4:37 am
I believe using the pre and post execute event handlers to call SPs in order to write to a auditing table is the most efficient and and less invasive method...
June 8, 2012 at 3:41 am
I think one important thing to note is that you would typically set up a template package with all of your variables and package configs all set up. By copying...
June 8, 2012 at 3:38 am
Thanks for your replies guys!
This is an outgoing process therefore I need to replace like for like ideally. I did try the casting as decimal route but without knowing how...
April 17, 2012 at 7:00 am
This is an existing process. The way the files are produced is changing to use bcp for speed.
The original process added double quotes around each field but bcp doesn't...
April 16, 2012 at 6:15 am
Great, thanks for your reply. That makes a lot of sense.
Problems is I have quite a few columns I need to make this change on! :crazy:
Going to take a...
April 16, 2012 at 5:11 am
Sorry, yes I should have been more specific when I said 'relevant backups'
February 10, 2012 at 8:48 am
Yes, I currently have this set up. I guess I'll just look at changing the existing classifier function to cater for the users/groups I am interested in
February 2, 2012 at 7:47 am
Viewing 15 posts - 16 through 30 (of 162 total)