<div>
check this<br />
<br />
<a href="http://blog.sqlauthority.com/2008/01/25/sql-server-2005-database-table-partitioning-tutorial-how-to-horizontal-partition-database-table/" rel="ugc">http://blog.sqlauthority.com/2008/01/25/sql-server-2005-database-table-partitioning-tutorial-how-to-horizontal-partition-database-table/</a>
</div>


check this

http://blog.sqlauthority.com/2008/01/25/sql-server-2005-database-table-partitioning-tutorial-how-to-horizontal-partition-database-table/ [http://blog.sqlauthority.com/2008/01/25/sql-server-2005-database-table-partitioning-tutorial-how-to-horizontal-partition-database-table/]

<div>
<div class="content wysiwyg-content">
SQL Server 2005 <br />
<br />
I collect monthly information in a big table. Can someone explain the steps I would need to take to partition the table by year?<br />
<br />
I understand there can be significant performance benefits for such partitioning of big tables. <br />
<br />

</div>
</div>


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. 



Partitioning large tables by year

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.