Could not get your point Gila

yes.

inorder to hide my business process i have renamed the column.

while pasting here i did not mention as b.column names for the columns.

For execution plan since it is having

Really sorry gail for not giving much informations.

Here is my DDL statements.

CREATE TABLE [dbo].[TABLE1](

[COL1] [uniqueidentifier] NOT NULL,

[COL2] [float] NOT NULL,

[COL3] [uniqueidentifier] NOT NULL,

[COL4] [float] NOT NULL,

[COL5] [varchar](64) NULL,

[COL6] [smallint] NOT...

i got this from profiler, so i dont have execution plan.

Thanks for that reference book, it is really nice.:-)

Thanks Gail for replaying in this SQL 2000 forum.

So if i am using Windows 2000 DataCenter as 32 bit OS , can it take 64 GB of RAM.

Thanks Gail for quick replay.

Then the Insert should be that much fast right if...

Yes similarly kind fof information i need but...

Just want the parent table name ,key name, child table name ,child key in the order

parent name,key name, child name ,child key

p1 k1 p2 k2

p2 k2 p3 k3

.

.

.

when...

Jeff Moden (4/1/2014)

---

My question would be, why do people insist on storing hierarchical data in multiple tables? It's usually SO much easier to store/maintain the data as a single...

Grant Fritchey (3/28/2014)

---

As I said before, your choices in 2000 are more limited. Filter the data on additional criteria to reduce the batch size so you're deleting in smaller chunks...

so what is the better solution to delete records in sql server 2000

The system is Standalone system.There will not be any user to see if there is an problem or not.

It should be auto- clear the issues.

That is main problem i am...

Here in the KB article SET ROWCOUNT has been used to delete large records.

http://support.microsoft.com/kb/323630

SET ROWCOUNT 500

delete_more:

DELETE FROM LogMessages WHERE LogDate < '2/1/2002'

IF @@ROWCOUNT > 0...

Grant Fritchey (3/28/2014)

---

If you are doing very large scale deletes, or inserts, it's fairly common to drop the foreign keys first. You just have to make sure you have good...