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

Articles with tag Partitioned Tables Rss

Search for any content tagged partitioned tables

   Items 1 to 7 of 7   

Creating a table with horizontal partitioning in SQL Server

During the planning phase I found out about the new partitioning feature in SQL Server 2005 and later editions of SQL Server. It is a vast topic with several associated operations and configurations involved. In this tip I will share what I learned about partitioning, show an example to implement horizontal table partitioning along with a comprehensive list of related benefits and considerations.  Read more...
By Additional Articles 2009/07/23 | Source: MSSQLTips.com | Category: partitioned tables
Rating: (not yet rated)  Rate this |   Briefcase | 3,969 reads

Partitioned Table and Index Strategies Using SQL Server 2008

The Microsoft SQL Server 2008 database software provides table partitioning to make such operations more manageable.  Read more...
By Additional Articles 2009/07/10 | Source: TechNet Blogs | Category: partitioned tables
Rating:  Rate this |   Briefcase | 2,901 reads

Configuring Replication for Partitioned Tables Using T-SQL

New author Michelle Ufford brings us an article that shows how you can replicate those partitioned tables in your environment.  Read more...
By Michelle Ufford 2009/01/29 | Source: SQLServerCentral.com | Category: partitioned tables
Rating: |  Discuss |   Briefcase | 4,256 reads

Solving the “Running Totals” Problem in SQL Server 2005 with Partitioned Tables

Lynn Pettis gives us a look at a new way to solve a T-SQL problem.  Read more...
By Lynn Pettis 2009/01/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 11,956 reads

Using Partitioned Tables with Multiple Filegroups for High Availability

Let us look at another means to increase the availability of your highly critical databases. We will extend the concept of filegroups as highlighted in a previous tip on Disaster Recovery Procedures in SQL Server 2005 Part 2 (Isolating Critical Objects) wherein we can use filegroups to isolate and store a critical object.  Read more...
By Additional Articles 2008/11/20 | Source: MSSQLTips.com | Category: high availability (ha)
Rating: (not yet rated)  Rate this |   Briefcase | 3,075 reads

How to Implement an Automatic Sliding Window in a Partitioned Table on SQL Server 2005

This article shows how to implement an automatic sliding window in a partitioned table on Microsoft SQL Server 2005.  Read more...
By Additional Articles 2008/04/11 | Source: TechNet Blogs | Category: sql server 2005
Rating:  Rate this |   Briefcase | 3,891 reads

Partitioning - Part 4

Continuing on with his series on table partitioning, Andy Warren takes a look at some fo the advanced features available in SQL Server Enterprise Edition.  Read more...
By Andy Warren 2008/01/17 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 7,106 reads
   Items 1 to 7 of 7