Grant Fritchey (3/28/2014)

---

You're posting in the 2008 forum.

Not sure what you mean by batch delete. SET ROWCOUNT just limits the rows returned, but the query plan and the access of...

i am using sql server 2000.

but why there is time difference?

why peoples are suggestung to use batch delete?

andrew gothard (3/27/2014)

Oh - and if you've made the mistake of update / delete cascade being set to on, do not delete from the parent table. Use an approach...

Sean Lange (3/27/2014)

---

True. I have worked with this OP on several threads and the problem is performance because they have several related tables and the primary key (and clustered index)...

Delete operation takes more or less same time i dont see any improvement in the query when i have batch delete. To delete some 1 million records.

atually the approach...

Coludn't get you.

You mean to say primary key clusterindex on the child tables??

Koen Verbeeck (3/21/2014)

---

If the maximum value is lower than the maximum int value, then choose int.

You don't need to know how SQL Server works internally just to create a table.

If...

Table max size will be of around 30-50 million records.

data type will be wil be storing some max size of 1829683708 (+/-5million) less than INT(2147483648).

how internally the records are readed...

You should see at least a 10x performance improvement versus single record delete. It will vary depending on how big you make the batch size for the delete. We have...

Actually DBCC Shrinkdatabase is back ground operation , it should not affect usual...

You are saying that there will be impact or how?

Sorry unable to get you.

Will there be any impact in insert or select or delete or update statement like slowness

Is there a better way to do so to delete the records checking with another table.

Table A is having 100k records

Table B is having 8000k records

When i delete the TableB with TableA record exists the query is taking long time thats why i...

declare @pdate datetime

set @pdate = getdate()-7

--Start by getting the records to delete

SELECT ID

INTO #DeleteKeys

FROM TESTDATA WITH (NOLOCK)

WHERE RUN_START_TIME <=@pdate

If i have refer another table for delete then will this...