Azure Cosmos DB Partitioning

One of the most important design decisions that must be made when planning deployment of Azure Cosmos DB involves logical partitioning of data that will populate target collections, graphs, or tables. Selecting the optimal partitioning model has both performance and pricing implications. In this article, we will explore the rationale behind these implications and review the partitioning options.

Loading partitions incrementally using SSIS

In this article, we discuss how to load large partition tables incrementally.

Creating Partition on Existing tables and Rolling Partitions

this article describes about creating partitions on our existing Tables and also gives details about how to create rolling partition to support new data

Cumulative sum of previous rows

I had an update statement that took 3 minutes to run after this code change it took 6 seconds.

Calculating the Median Value within a Partitioned Set Using T-SQL

It is ironic that one of the most essential of statistical aggregations, the median, has been so difficult in the past to calculate efficiently in SQL. Dwain Camps sets the candidates to work and identifies the winners and losers.

Archiving SQL Server Data Using Partitioning

Many companies now have a requirement to keep data for long periods of time. While this data does have to be available if requested, it usually does not need to be accessible by the application for any current transactions. Data that falls into this category are a good candidate for archival.

Partition SWITCH

Creating and managing Analysis Services partitions

S partitions from the ground up, with advice on binding, merging, and selecting partition data.

Partitioning in SQL Server 2008

This article discusses about 'Partitioning'. In this detailed article, a particular emphasis is placed on the implementation of Partitioning in SQL Server.

Insertion and Deletion by using Partition

for huge data insertion and deletion by avoiding locking you can use partition tables.