October 26, 2006 at 3:00 pm
Are there any best practices for determining when/how partitioning is indicated?
Number or Rows
Size of Table
Number/Size of Indexes?
October 27, 2006 at 8:15 am
There arent any fixed rules on when to use horizontal partitioning, but its generally suitable for large tables, particularly if you have a sliding window scenario with historical data in the same table as current data.
A good rough startting point is tables having more than a million rows. The following article by Kimberly Tripp (one of my favorite people in the world) may help you decide.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5partition.asp
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy