Tags » Partitioning

Strategy for tuning VLDB

I have been thinking to write this post for quite sometime. I thought it will be good to share my success story of making a VLDB run super fast. 924 more words

SQL DB Engine

Table Partitioning : Have you chosen a right partition column?

It’s been long time I’ve written any post and I’ve always been thinking of writing something unique. Finally, I got something  :) .  Normally, I prefer to write long posts but this time I will try to keep it brief and precise. 1,138 more words

SQL DB Engine

Setting up a USB powered hard disk on my Raspberry Pi – Part II (create a partition with fdisk)

Following up with the first article of the series, I’m now going to explain how to create a new partition with an ext4 file system in it using the Linux command tool… 291 more words


An example of where the optimizer should ignore a hint

Here’s an example of where the optimizer really should ignore a hint.

I’m testing an implementation of deliberately unusable index partitions – i.e. some empty index partitions, some usable. 133 more words


How much do office partitions cost?

There are many different types and configurations of office partitions available but the basic types are metal stud partitions, aluminium partitions and frameless glazed partitions. 447 more words

Aluminium Partitions

Table Partitioning - IO_COMPLETION waits during INDEX REBUILD

If the partitioning MERGE command is executed for the wrong range after a SWITCH OUT of historic data, movement between file groups may be necessary before or during the next index rebuild. 1,759 more words



Dialrack have for the last 2 decades been a leader in the commercial and industrial refurbishment market.

This knowledge and experience, coupled with some of the… 112 more words