Link to home
Create AccountLog in
Avatar of LennyGray
LennyGrayFlag for United States of America

asked on

Partitioning large tables by year

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.

Avatar of Kalpesh Chhatrala
Kalpesh Chhatrala
Flag of India image

ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of LennyGray

ASKER

Thanks!