Creating database objects For vertically partitioned scenarios, elastic query extends the current T-SQL DDL to refer to tables that are stored on remote databases. This section provides an overview of ...

In addition to indexes and materialized views, horizontal and vertical partitioning are important aspects of physical design in a relational database system that significantly impact performance.

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 ...

Distributed databases on cluster computers are widely used in many applications. With the volume of data getting bigger and bigger and the velocity of data getting faster and faster, it is important ...

Vertical and horizontal partitioning are physical database design techniques that can considerably improve query response time in distributed database system. Although most current database management ...

Procedure to move Microsoft SQL Server database to a new location, painlessly, if you’re running low on disk space, added a new drive array, or just curious.

Elastic database query for cross-database queries (vertical partitioning) This document explains how to setup elastic query for cross-database querying scenarios (vertical partitioning) and how to ...