Viewing 15 posts - 31 through 45 (of 162 total)
The DDL for the dimension table is below - note I have replaced the business field names:
There is a unique clustered index on RowID, a non clustered on RowStartDate and...
February 2, 2012 at 2:22 am
Personally I think the use of views in a OLAP environment is fundamental to a flexible design.
Not only does it provide a layer of abstraction but crucially it helps support...
January 10, 2012 at 8:10 am
Also do you need to compare the entire source dataset each time.
Is there anything that helps you to identify which records are new or have been updated since the...
January 10, 2012 at 7:49 am
Don't think this is SSIS. Certainly sounds like permissions to me.
When you see this error are you running the package in bids from your own machine or using SQL...
January 10, 2012 at 7:24 am
Yes, I did. But I have removed it, updated the stats, recompiled the sp and have executed again.
Going for 70 mins so far when it usually takes 40
September 16, 2011 at 4:10 am
Sure there are several indexes on the target table and they have always been there.
My point is that now everything is structurally the same, the data is the same, the...
September 16, 2011 at 3:56 am
Ok well there shouldn't be any more inserts than normal, the data has simply moved on a day.
I have already kicked off the query and it is running well from...
September 16, 2011 at 3:20 am
Hi sorry, forgot to mention I had already carried out a global update stats on the staging database.
And there was one thing which did change - this was the...
September 16, 2011 at 2:47 am
No so happy as this is in the UAT environment, it somehow worked ok in the dev environment and who knows what might happen in production!
I will continue to work...
June 21, 2011 at 5:59 am
Ok listen to this. If I set up a proxy account a link it to the SQL Server agent domain account it works?? Something is not quite right when the...
June 21, 2011 at 5:13 am
Yep, I've done that too.
I copied the files onto the server, update the connection and it worked from the job fine. It just will not hit a UNC path from...
June 21, 2011 at 3:50 am
Yes, from a SQL Server Configuration table.
June 21, 2011 at 3:36 am
Here's an example of one of them
\\bhdata1\eig\Central\QMS\Archive\qlextlivi4.csv
June 21, 2011 at 3:23 am
Ok guys thanks for your advice to date.
I wanted to provide somekind of update to where my findings have led me, any feedback is welcome as always.
So I posted originally...
June 12, 2011 at 5:15 am
I think you would still need a lookup table to idenify the business key? This cannot be physically defined on the table as a primary key as the table is...
May 4, 2011 at 1:05 pm
Viewing 15 posts - 31 through 45 (of 162 total)