Viewing 15 posts - 1 through 15 (of 20 total)
Great article! I know now what I didn't understand until now. Thanks
December 30, 2015 at 7:30 am
I am happy you liked the article, use it as it is most suitable for you!
@jpratt nice idea to use a tooltip!
@Naseer of course the version can be...
August 7, 2015 at 1:45 am
Hi Daniel, inspired by your article, I am planning to build my own index maintenance script. To overcome some of the problems mentioned in the discussion, I am planning...
September 25, 2014 at 1:30 pm
Great solution and interesting article. I see your point of view, but the world is not entirely black and white. I also think automated index maintainance is risky, but hey,...
June 26, 2014 at 6:50 am
I am using SSDT to manage projects for which I am deploying different versions for each customer, based on the same main code.
I have solutions for the following issues:
May 4, 2014 at 7:32 am
sneumersky: I guess I should try to get a copy of the Microsoft Data Warehouse Toolkit. Thanks for the tip.
Can you give me some hints on the indexing strategy...
August 22, 2013 at 1:54 am
Yes, you are right. I mixed up some things and simply assumed I did it correct. So I had to do my homework again. The correct indexes are as...
August 21, 2013 at 2:27 am
Thanks to all you guys on the update on dimensional modelling.
Since I also attended Kimballs courses I am aware of the 'problem'. Maybe I should have called my solution a...
August 20, 2013 at 4:25 am
No there is no PK violation because a new InvoiceID is generated for the previously deleted record. So we end up with two records, one with a negative validity...
August 20, 2013 at 3:42 am
The main improvement was definitely achieved by reducing the number of records.
But also the indexes have a considerable influence. With the correct index loading speed was reduced by half.
August 19, 2013 at 12:50 pm
The main improvement was achieved by reducing the total number of records. In addition, the indexes improved load and query speed, while not substantially increasing storage speed.
In my first attempts,...
August 19, 2013 at 10:23 am
Renato10: I know, but I am not the first to use this term when applying SCD logic on a fact table. Have a look at http://brentgreenwood.blogspot.com/2011/12/slowly-changing-facts.html for example.
The solution presented...
August 19, 2013 at 5:46 am
You can find the zip file at the bottom of the article under Resources.
August 19, 2013 at 4:10 am
I am sorry but it seems I made an error in the code inserted in the article.
I forgot to define PRIMARY KEYS for the DI_Customer and DI_Bucket tables on the...
August 19, 2013 at 3:19 am
I agree with the above comments, it should be wider and it would be nice to have the featured content back on top.
Otherwise I like the font and the colors...
July 2, 2013 at 7:00 am