100 million data retention 5 delete other quick way to do what? A launch title, I'm fucking was despised. No ... delete not in use

Category: MS-SQL Server -> Foundation Classes Author: shuizy35 Date: 2009-06-04 11:51:55
 
shuizy35
2009-06-04 11:51:55
100 million data retention 5 delete other quick way to do what? A launch title, I'm fucking was despised. Not delete not in use ...

other experts to answer.
jyzjtxwd
2009-06-04 12:01:01
select 5 pieces of data into # temp table from 1 million data cattle X table

truncate table 1 million data cattle X Table
- let cattle X, less than 10 milliseconds to kill it.

insert 1 million data cattle X table select * from # temp table

drop table # temp table
sukai98
2009-06-04 12:19:25
1, check out the first five of which is inserted into a table

2, then the 100 million data table drop table

3, the Which five data table name is changed to the previous table
shunjingwei
2009-06-04 12:33:45
set rowcount 99999995

delete from Table

set rowcount 0
addin2009
2009-06-04 12:42:00
Halo ... use DELETE to delete the MSSQL estimate is unlikely to be able to finish it.
wenyaozxw
2009-06-04 12:49:18
Support kill cattle X Table
lianghe2009luck
2009-06-04 12:54:08
delete from not in this way will remove the dead; ^ _ ^
qqwweea030
2009-06-04 12:56:17
story house, you gave He got up name too cute, had to praise, ha ha
jj8841
2009-06-04 13:05:39
You can use the following statement:
delete from Table where Column not in (select column from Table where Condition)
first find out which five records, and then use the Delete command to delete a record five outside.
lbzai
2009-06-04 13:13:31
trancate then one by one insert
chalixu
2009-06-04 13:25:36
truncate table
igbg
2009-06-04 13:38:41
zhichi
xznuvf
2009-06-04 13:51:47
1, select * into # test from table_Pqs where ... (5 records)
2, truncate table table_Pqs
3, Insert Into table_Pqs select * ; from # test
4, Drop table # test
lwzlh
2009-06-04 14:04:25
Passing learn :)
mengmeng250
2009-06-04 14:22:28
agree with truncate
niaqigan
2009-06-04 14:28:29
agree cattle X Table `
lonelunee
2009-06-04 14:32:19
Haha, truncate
xuqq2001
2009-06-04 14:45:20
truncate Bull X Table nice
jiufei1983
2009-06-04 15:02:28
1, select * into # test from table_Pqs where ... (5 records)
2, truncate table table_Pqs
3, Insert Into table_Pqs select * from # test
4, Drop table # test
agree with this point of view, the use of truncate, delete it if one is slow, there is one if he would write to the log,
then let the database log file increases.
anyway, use the delete is not good.
tukela112
2009-06-04 15:14:48
Support truncate Bull X Table

Page 1 of 3    «  »