Solved

Partitioning large tables by year

Posted on 2011-02-15
3
330 Views
Last Modified: 2012-05-11
SQL Server 2005

I collect monthly information in a big table. Can someone explain the steps I would need to take to partition the table by year?

I understand there can be significant performance benefits for such partitioning of big tables.

0
Comment
Question by:LennyGray
3 Comments
 
LVL 16

Expert Comment

by:Kalpesh Chhatrala
ID: 34903691
0
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 500 total points
ID: 34903705
3 step process,
creating a partition function for year
partition scheme
partitioning the table

its described here
http://databases.about.com/od/sqlserver/a/partitioning.htm
0
 
LVL 10

Author Closing Comment

by:LennyGray
ID: 34917358
Thanks!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now