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? […]

 

Total index maintenance

There is no magic in indexes. Instead, it is all about timing and balance.

A few quick word on index structures – nothing deep here, I am sure if you are reading this, you already know enough about index structures:

indexes are organized in B-trees, i.e. leaf structures comprised of hierarchical pages, pointing to each other
there are

Continue reading […] Total index maintenance […]