从表中删除后数据库大小变大

从 SQL Server 数据库表中删除大量数据后，数据库大小增加.

After I delete huge amount of data from a SQL Server database table, the database size increased.

当我运行 sp_spaceused 时，它显示 2625.25 MB.在我从表中删除之前，它曾经是 ~ 1800.00 MB.

When I run sp_spaceused it shows me 2625.25 MB. It used to be ~ 1800.00 MB before I deleted from table.

有什么具体的原因，即使我删除了数据，它也会继续增长吗?

Is there any specific reason it keeps growing even if I delete data?

临时事务日志通常是大量删除后大小显着增加的原因.

A temporary transaction log is often the reason for a notable increase of size after a huge delete.

它最终会自行消失，但如果您需要回收空间，您可以删除这些文件.

It will eventually disappear on its own but you may remove the files if you need to reclaim the space.

推荐阅读

热点文章