SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag partition Rss

Search for any content tagged partition

   Items 1 to 10 of 10   
 

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.  Read more...
By Additional Articles 2018/03/08 | Source: Database Journal | Category: azure cosmos db
Rating: (not yet rated)  Rate this |   Briefcase | 2,226 reads

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  Read more...
By Avinash Gunjuluri 2016/09/12 | Source: SQLServerCentral.com | Category: partition
Rating: |  Discuss |   Briefcase | 1,976 reads

Cumulative sum of previous rows

I had an update statement that took 3 minutes to run after this code change it took 6 seconds.  Read more...
By Ben Kubicek 2015/03/27 (first published: 2014/05/08) | Source: SQLServerCentral.com | Category: cumulative
Rating: |  Discuss |   Briefcase | 14,719 reads

Cumulative sum of previous rows

I had an update statement that took 3 minutes to run after this code change it took 6 seconds.  Read more...
By Ben Kubicek 2015/03/27 (first published: 2014/05/08) | Source: SQLServerCentral.com | Category: cumulative
Rating: |  Discuss |   Briefcase | 14,719 reads

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.   Read more...
By Additional Articles 2014/01/22 | Source: SimpleTalk | Category: median
Rating:  Rate this |   Briefcase | 3,764 reads

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.  Read more...
By Additional Articles 2012/10/22 | Source: MSSQLTips.com | Category: archiving data
Rating: (not yet rated)  Rate this |   Briefcase | 3,848 reads

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.  Read more...
By Muhammad Shujaat Siddiqi 2010/10/01 (first published: 2009/04/29) | Source: SQLServerCentral.com | Category: partition
Rating: |  Discuss |   Briefcase | 56,032 reads

Creating and managing Analysis Services partitions

S partitions from the ground up, with advice on binding, merging, and selecting partition data.   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,481 reads

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.  Read more...
By Muhammad Shujaat Siddiqi 2010/10/01 (first published: 2009/04/29) | Source: SQLServerCentral.com | Category: partition
Rating: |  Discuss |   Briefcase | 56,032 reads

Name Value Pair - Part II

In this article I will try to address some of the design suggestions and experiences that I had in managing similar database.  Read more...
By Teshome Asfaw 2008/05/19 | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 7,364 reads
   Items 1 to 10 of 10