Great article! I know now what I didn't understand until now. Thanks

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...

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...

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,...

Hi,

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:

-...

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...

Hi mb97!

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...

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...

Hi mb67!

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...

Nick,

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.

However, every...

Nick,

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,...

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...

You can find the zip file at the bottom of the article under Resources.

Hi!

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...

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...