MS SQL Server ODBC - SQL server 2000 vertical partitioning

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

SQL server 2000 vertical partitioning

Nada Sherief

2005-11-08, 9:23 am

hello
i want someone to help me in solving a problem in sql server 2000

considering that i have a table named PROJ(JNO,JNAME,BUDGE
T,LOC) where JNO
is the primary key of this table
also this table is related to another one, where the other table has a foreign

key to this table.

i want to perform vertical fragmentation (partitioning) on SQL server 2000:

as an example take the relation PROJ and divide it vertically into two subrelations
PRO1 and PRO2. PRO1 contains only the information about project budgets,
whereas PRO2 contains the project names and locations.

please try to send me the code (with comments) and a detailed step-by-step
of how to run this code so that i have these tables fragmented on the two
servers.

or if they don't need code, i hope you send me a step-by-step support of
how to do all these fragmentations on SQL server 2000.

Thanx all

Sponsored Links