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

Content with tag Partitioned Tables Rss

   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,520 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,539 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 | 3,814 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,789 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 | 2,736 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,584 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 | 6,982 reads
   Items 1 to 7 of 7   
 
Tags
sql server 2005 (2)    
filegroups (1)    
high availability (ha) (1)    
indexing (1)    
replication (1)    
running totals (1)    
sql server 2008 (1)    
t-sql (1)