|
Home > Archive > MS SQL Server > December 2006 > Horrizontal partition
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Horrizontal partition
|
|
|
| Hi,
I see that SQL Server 2005 can split db based on some values of some
columns.
I need in MS SQL server 2000 to bakup old data from table and
eventually restore.
I've a colum with the year. I Want to archive based on year.
Have you suggestions?
| |
| AlterEgo 2006-12-01, 7:13 pm |
| SP,
The partitioning column must be part of the primary key. If you use an
identity column as the primary key, then you might be able to associate the
end of year with a specific key value and set up your constraints
accordingly.
-- Bill
"SP" <dario.zandolin@gmail.com> wrote in message
news:1165016099.285719.137940@79g2000cws.googlegroups.com...
> Hi,
>
> I see that SQL Server 2005 can split db based on some values of some
> columns.
> I need in MS SQL server 2000 to bakup old data from table and
> eventually restore.
> I've a colum with the year. I Want to archive based on year.
> Have you suggestions?
>
| |
| JayKon 2006-12-02, 7:14 pm |
| This is the first I've heard of this in SQL Server. I looked for documents on
the Microsoft site, but only found references to Data Wharehousing.
Is this splitting the data file onto multiple disks/partitions so that the
engine can do fragment elemination on a query? If so, I would think it has
more applications in OLTP than DSS.
FYI, Informix does this and (if setup correctly) allows sub-second response
times while the system is heavially impacted.
"SP" wrote:
> Hi,
>
> I see that SQL Server 2005 can split db based on some values of some
> columns.
> I need in MS SQL server 2000 to bakup old data from table and
> eventually restore.
> I've a colum with the year. I Want to archive based on year.
> Have you suggestions?
>
>
| |
|
| But what I need to do in sql server 2000?
There is some link to do it?
I don't understant how implement this partition?
Some samples?
Thanks
AlterEgo ha scritto:
[color=darkred]
> SP,
>
> The partitioning column must be part of the primary key. If you use an
> identity column as the primary key, then you might be able to associate the
> end of year with a specific key value and set up your constraints
> accordingly.
>
> -- Bill
>
> "SP" <dario.zandolin@gmail.com> wrote in message
> news:1165016099.285719.137940@79g2000cws.googlegroups.com...
|
|
|
|
|