Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Table Partitioning Help Expand / Collapse
Author
Message
Posted Friday, November 30, 2012 5:47 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, February 22, 2013 9:10 PM
Points: 25, Visits: 112
Hi Gurus,

Is someone can help me with Table Partition? with e.g or show me tutorial that would be awesome.

Thanks in advance.
Post #1391599
Posted Sunday, December 2, 2012 10:56 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 12:13 AM
Points: 745, Visits: 4,776
MSKB is your friend... that and Books Online.

http://technet.microsoft.com/en-us/library/ms188730.aspx
Post #1391772
Posted Sunday, December 2, 2012 11:09 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, June 12, 2014 2:04 PM
Points: 1,789, Visits: 1,014
http://blog.sqlauthority.com/2008/01/25/sql-server-2005-database-table-partitioning-tutorial-how-to-horizontal-partition-database-table

The above link has scripts that u can use , I suggest you first read up on partition function and partition scheme before trying them out. Also you need to understand that table partitioning is mainly used to manage a large table t you need to identify the right column on which to partition by and how to use the swap of partitions.


Jayanth Kurup
Post #1391774
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse