So if i move to Big int data type then will there be performance improvement?

here i am mainly concern about data reading(Select).

No. I dont wnat this column to be...

Yes for sure i am...

As i said since the data is growing large and large having uniqueidentifier and querying the data might takes time.

Inorder to reduce the time in future to insert the data...

Yet to test process, before that getting into the process,ensuring that the process which i have followed is ok or need to modify.

Next thing is can we hold GUID itself...

You...

Thanks Sean!

I got it we should not go with cluster index for guid since this will cause physical ordering of the data on the disk which is pointless one.

One more...

I think you are inserting data into TableA which has a uniqueidentifier as the clustered index? That is source of your problem. The index fragmentation is going to be through...

As i said

TableA C1 uniqueidentifier (PK), C2 uniqueidentifier, C3 ......

PK is a cluster index

TableB C1 uniqueidentifier(PK) , C2 uniqueidentifier (FK_TableA_uniqueidentifier ), C3 ......

Column c1 PK is a cluster index and...

Plan to get a new server for SQL2008 and migrating the dbs to it.

Main concern over the migration is performance improvement.

We are using 4gb of RAM for the current client,...

Hi EricEyster,

After having bacth operation is delete operation faster?

how much time you gained after rewritting your query.

Incase what if in lower version of sql server say sql server 2000 how...

So u mean to say

Delete from main_table where id=some_input;

Delete from Child_table1 where id=some_input;

Delete from Child_table2 where id=some_input;

Delete from Child_table3 where id=some_input;

Commit tran;

So steve you are suggesting some thing like

EXEC ('DELETE Top (10000) FROM '+ @Table_Name +' WHERE RUN_START_TIME<=' + @pdate + '')

COMMIT TRAN

DELETE Top (10000) TESTDATA WHERE RUN_START_TIME...

Grant Fritchey (3/5/2014)

---

Cascade delete is pretty dangerous. I don't know of many people that use it. It tends to create very large transactions that lead to lots and lots of...

Steve Jones - SSC Editor (3/3/2014)

---

One big thing would be to move to a stable x64 platform. That was an add-on in SQL 2000, but in SQL2K8 you can easily...