Posted by rcamarda on 10/05/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

• Next in forum: I HATE Management Studio, how about you?
• Prev in forum: BCP using ODBC - problem with unique identifier
• Thread view: Re: Smarter Table build - might split the table

[Reply to this message]