vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Just started a new position and I am looking at partitioning some tables. I have one that is over 500 million rows. The site is basically 24 x 7 so my window will be short. I am looking for the best approach. While performing searches, I came across this and I am interested in finding out more so that I can either consider or rule it out as a possability. I have tested out my partitioning scripts locally on my developer copy of sql server. Everything works as advertised, so my only concern at this point is getting the data from the main table to the partitioned table in the most efficient manner. |