Data Partitioning in SQL Server was introduced in the 2005 release. This was a feature that had been in Oracle and IBM’s DB2 for a while, but Microsoft is positioning to compete in the VLDB market ...

All these terms i.e., partition, volume, and logical drive are data storage units. But there are differences that we have tried to cover in this post below. Let’s learn about them one by one. A ...

Data Partitioning is a very useful feature in SQL Server 2005 and beyond. I have discussed this database feature in previous blog entries but it is also available in SQL Server Analysis Services which ...

A single partition feels simple until something goes wrong ...

Drive partitioning is not the hot thing that it once was.

Partitioning can provide a number of benefits to a sharding system, including faster query execution. Let’s see how it works. In a previous post, I described a sharding system to scale throughput and ...

Merging disk partitions is useful to optimize disk space, especially when managing multiple partitions on a single disk. However, Windows Disk Management can only merge adjacent partitions, and it ...

I have a 60GBHDD that I am using to upgrade my laptop.<BR><BR>I understand the theory of virtual partitioning to<BR>- save defrag time<BR>- save data if you need to reinstall<BR><BR>But where is best ...