Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag partition Rss

Search for any content tagged partition

   Items 1 to 7 of 7   
 

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 2014/05/08 | Source: SQLServerCentral.com | Category: cumulative
Rating: |  Discuss |   Briefcase | 10,916 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 | 2,592 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
Rating: (not yet rated)  Rate this |   Briefcase | 3,320 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 | 54,723 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 | 1,969 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 | 54,723 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,341 reads
   Items 1 to 7 of 7