Reply to Re: Smarter Table build - might split the table
Posted by rcamarda on 11/29/08 11:52
Upon more research in this news group, it looks like I should look at
horizontal partitioning.
I am using SQL 2005 Enterprise, so I should be able to use partitioned
data and indexes.
If I partition on year, what should I consider to make this as
maintenance free as possible (what happens where a new year comes?)
TIA
Rob