Category: Databases

General Database Posts

How to move tables, indexes and partitions to a different tablespace in Oracle

How to move tables, indexes and partitions to a different tablespace in Oracle

I had a case where I needed to move objects to a new tablespace, quite a few objects. As there was a lot of objects (tables, indexes and partitions) I decided to automate the code creation from the database metadata. Moving Objects To A New Tablespace The first thing to understand is how to move…

Read More Read More

Querying SQL Server with something LIKE a regular expression

Querying SQL Server with something LIKE a regular expression

Most of us are familiar with the LIKE command in SQL Server (and other DBMS environments), but few venture beyond simple text matching and the ‘%’ wildcard. It’s ability to use some regular expression (a.k.a. regex or regexp) syntax is a surprise to many. For this article, I’m assuming that readers have already used the…

Read More Read More

Object Catalog Views: Table Metadata

Object Catalog Views: Table Metadata

It’s handy to programmatically get metadata on tables (column names and datatypes), either to review implementation, or as part of a process automating code creation.

Partitions in SQL Server: A collection Of Thoughts

Partitions in SQL Server: A collection Of Thoughts

Like when I started writing about Dates in SQL Server, a couple of notes on partitioning has turned into a series… And not one I’m so happy with (I had a lot to cover and at the same time a lack of a bigger picture direction). Rather than ramble on about aspects of partitioning in…

Read More Read More

Partitions in SQL Server: Partition an Existing Fact Table (by date)

Partitions in SQL Server: Partition an Existing Fact Table (by date)

Picking up on my series on partitioning, previously I looked at¬†Partitions in SQL Server: Creating a Partitioned Fact Table (by date) now I’m going to look into splitting an existing table into partitions. A key thing to remember is that the moving of data on disk can be time consuming and cause locks. The approaches…

Read More Read More