Tags » Partitioning

Rebuild a Standard Table to a Partitioned Table

I have been working on a SQL DW database and revisiting an existing SQL table partitioning scheme.  The main reasons we’re going to all this trouble is to (a) implement a full partition based optimisation process and (b) implement a partial database backup scheme. 1,607 more words

SQL Server

Software integrity level partitioning

A short tutorial on the architectural principles of integrity level partitioning,  I wrote this a while ago, but the fundamentals remain the same. Partitioning is a very powerful design technique but if you apply it you… 69 more words

Reference Partitioning on Star Schema: A Good Idea?

In my last blog post, I noticed that surrogate keys on a time dimension cannot be combined with partitioned fact tables in a star schema. 1,128 more words


Automatic Data Purging With Partition Switching

In a previous article I showed a basic example of Partition Switching, using animal names (https://wp.me/p3Vxvi-2u). While not a realistic example for everyday use it did get the principles across. 1,209 more words

Partition Switch

Time Dimension Keys and Partitioning

In the physical design of a star schema, it is recommended to use surrogate keys for the primary keys of dimension tables. Except for the time dimension. 1,860 more words


Optimizer statistics - Stale percentage and partitioning

Oracle is full of surprises, dbms_stats and optimizer statistics as well. That’s why I’m starting a new series named “Optimized statistics” in which I’ll cover some gathering and usage issues related to them. 711 more words


The value of getting your office refurbished

Should you choose not need an essential element as it pertains to producing your workplace room take a look at its greatest having your workplace restored is he job could be a bit difficult. 411 more words