Pushing the boundaries, going forward

Ever since I remember myself, when I was 3 or so, I remember having this big fat constantly hanging question “And what if I try this?“.

The question itself is simple, but it is so alluring that it is impossible to resist.

And it does not come cheap: I have broken many toys (as a kid) and

Continue reading […] Pushing the boundaries, going forward […]

 

Can partitioning solve it all?

Recently I got a question:

We are thinking to use partitioning for our DW database, since we have monthly incoming data of 30 million rows and partitioning will make the reads and writes much faster; we are using a 2 CPU machine with 16 Gb, 2 hard drives of 500Gb each.

Could you recommend a good strategy

Continue reading […] Can partitioning solve it all? […]