BE SHARING

Partitioning

SQL Server database design – Moving table to new filegroups

15.11.2021 by Christophe Cosme

Introduction A database is very often created without thinking of its growing and in the most cases that is not really an issue until the data volume is not increasing a lot. And most of the time when a high(…)

Database Administration & Monitoring

Oracle 12cR2 : Partitioning improvements – online conversion of a non-partitioned table to a partitioned table

06.01.2017 by Joël Cattin

It’s time to a new blog about partitioning improvement in 12cR2. After auto-list partitioning and multi-column list partitioning & read-only partitions, I’ll demonstrate how we can easily convert a non-partitioned table to a partitioned(…)

Database Administration & Monitoring

Oracle 12cR2 : Partitioning improvements – multi-column list partitioning & read-only partitions

16.12.2016 by Joël Cattin

In my last blog post I presented auto-list partitioning, a new partitioning functionality coming with 12cR2. In this one I will introduce two others : multi-column list partitioning and read-only partitions. Multi-column list partitioning Image :(…)

Database Administration & Monitoring

Oracle 12cR2 : Partitioning improvements – auto-list partitioning

08.11.2016 by Joël Cattin

The second release of Oracle Database 12c (12cR2) comes with new improvements regarding partitioning. In this blog post I’ll show one of them : auto-list partitioning. Auto-list partitioning is an extension of list partitioning. It enable the automatic(…)

Database Administration & Monitoring

Partitioning – When data movement is not performed as expected

13.10.2016 by Microsoft Team

This blog is about an interesting partitioning story and curious data movements during merge operation. I was at my one of my customer uses intensively partitioning for various reasons including archiving and manageability. A couple of days(…)

Database Administration & Monitoring

SQL Server 2016: TRUNCATE PARTITIONS with sliding Windows scenarios

08.10.2016 by Microsoft Team

Some time ago, I had to deal with a new partitioning scenario that included sliding windows stuff for mainly archiving purpose. Regarding the customer context, I used some management scripts that include this time dropping oldest partition. We didn’t care about(…)

Database Administration & Monitoring

SQL Server: switch partition and metadata inconsistency issue

30.04.2016 by Microsoft Team

In this blog post, I would like to share with you a weird issue I faced when I implemented a sliding Windows partition scenario on SQL Server 2014 SP1 at one of my customer. The idea was to keep SQL(…)

Development & Performance

Changing an existing partition configuration … Well, not so easy!

26.02.2016 by Microsoft Team

This time let’s talk about an interesting customer scenario where table partitioning was implemented on a table with 100 GB of data on SQL Server 2014. Partitioning in this context aimed to save disk space (archive data were compressed) , help(…)

Database management

Oracle 12c: Partitioning enhancements Part II – Other improvements

13.09.2013 by Oracle Team

Oracle Database 12c offers several enhancements for partitioning. In a previous blog posting, I talked about reference partitioning enhancements. This post will present other enhancements in relation to general partitioning. Asynchronous index maintenance With Oracle database, a global index(…)

Database management

Oracle Database 12c: Partitioning enhancements Part I – Reference partitioning

05.08.2013 by Oracle Team

Oracle Database 12c offers several enhancements for partitioning. This blog posting will present some enhancements in relation to reference partitioning. The differences between the Oracle 11g R2 and Oracle 12c releases will be shown using practical examples. TRUNCATE and(…)