SQL Server 2005 - Partition Existing Table with 11 million Rows
Posted on 2010-08-18
Hello, I'd like to partition a large table containing products for a price comparison type search system.
Right now it takes a bit too much time to pull records from the table. it's fairly acceptable, but I suspect it can be much faster with partioning.
I'd like to partition by the first letter of the store's name. I've already setup a column which stores this data.
My main issue is, I understand how i'd like to break this up, but I don't understand how to implement.
If anyone could give me extremely detailed code or even point me to an existing 3rd party tool which can do this for me I'd appreciate it.
The table name is products, the column I created with the A-Z value is ProgramNameStart.
If I need to provide more details please do let me know,