截断语句占用太多时间

删除表中的所有索引,然后截断,如果要插入数据,请插入数据,插入数据后重新创建索引

从Azure中删除时,您可能会遇到各种各样的麻烦,但截断几乎总是一个锁定问题。如果你无法解决这个问题,你可以在从Azure删除时始终使用这个技巧。

declare @iDeleteCounter int =1
while @iDeleteCounter > 0
begin
    begin transaction deletes;
    with deleteTable as
    (
        select top 100000 * from  mytable where mywhere
    )
    delete from deleteTable
    commit transaction deletes
    select @iDeleteCounter = count(1) from   mytable where mywhere

    print 'deleted 100000 from table' 

end