Solved

Partitioning large tables by year

Posted on 2011-02-15
3
332 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

808 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