Databases today are the heart of any business. Holding literally tons of information they indirectly are responsible for managing personnel, workflow, finances, supply and delivery of goods, inventory balance and other crucial data. No wonder, businesses are totally dependent on fluent operation of databases, which is impossible without timely maintenance and servicing

Sooner or later every DBA needs to purge old data from database tables. And it often happens that such tables are large enough. This can be done using table partitioning. Such approach is used rarely but in case of really large table it is very useful. In this article we`ll show an example of data purging based on partitioning from real life experience.