Viewing 15 posts - 1 through 15 (of 162 total)
Ok let me try and answer some of your questions:
1. Amongst other objects there is a Dim application and contract as well as a Fact application (granularity is...
October 12, 2017 at 3:02 pm
Ok this is the draft query which works using DeviceID to base the EventID on. I have had to use a where loop in order to set the value so...
April 14, 2014 at 3:13 am
The 1st problem I have is I need to track the previous EventID. Here is what I have so far when partitioning on DeviceID. Looking at DeviceID 100 then row...
April 14, 2014 at 2:28 am
Ok thanks for the replies so far. I checked out that link and it makes sense but I cannot make something like that work for my particular problem.
Here is the...
April 14, 2014 at 1:45 am
@Koen yes, they were just a couple of many examples.
The difficulty comes when you are attempting to prove in the design stages that their proposed solution will be more difficult...
March 10, 2014 at 2:57 am
Very interesting response Jeff. I guess a lot of people on here would echo your comments.....and like to have someone who you describe working in their team!
I guess the key...
March 10, 2014 at 2:24 am
Really interesting thread. I happen to have just inherited a database which has been thrown together with no filegroups or partitioning and this has a table or 500GB (2...
March 6, 2014 at 1:31 am
That sounds like a sensible approach. Some good points, thanks Keith.
Anyone else any other views?
February 11, 2014 at 9:28 am
Keith, would you state that you wouldn't be prepared to commence on the project until you had these commitments from the management. It my experience it is very difficult to...
February 11, 2014 at 9:21 am
I have came across the crosstab query before but only in theory, never used it in anger! I'll give this a go.
Thanks for your help, greatly appreciated.
December 31, 2013 at 8:29 am
Sorry for the delay Micheal, as I mentioned I only included a condensed list of fields, other I can think of which are included are order description for example. The...
October 24, 2013 at 1:47 pm
A little difficult to currently (not in the office or on a PC!!) I'll give it a shot...forgive any syntax errors!
So DimOrder is snowflakes to DimProduct and this is a...
October 22, 2013 at 3:47 pm
OK so the reason behind this is a follows:
1. I need to create several type 2 dimensions from OLTP tables which have been put together as track historical data changes...
October 21, 2013 at 1:27 pm
If a record is valid from '1900-01-01' until '2013-10-03' I will end up extracting it each day between these two dates using the method described above.
October 3, 2013 at 4:06 am
September 24, 2013 at 2:38 am