MS SQL Server Tools - SQL server 2000 fragmentation

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 fragmentation

Nada Sherief

2005-11-08, 4:10 pm

hi,

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 horizontal fragmentation:

I want to divide the table PROJ into 2 relations. Subrelation PROJ1 contains
information about projects whose budgets are less than $200,000, whereas
PROJ2 stores information about projects with larger budgets.

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