问个很低级的问题：truncate 一个 table takes forever - Database版 - 未名存档

本页内容为未名空间相应帖子的节选和存档，一周内的贴子最多显示50字，超过一周显示500字访问原贴

Database版 - 问个很低级的问题：truncate 一个 table takes forever

相关主题
● Re: Is there any easy way to truncate the LDF file of SQL SERVER?	● Database Interview Questions
● Oracle求助，thanks!!!	● SQL 2005 Intergration Service Q
● Import data from excel into sql server 2000	● sql server 怎么关掉log
● Truncation error import csv file to SQL table	● delete
● Is there any easy way to truncate the LDF file of SQL SERVER?	● error file或者exception file
● Access 'memo' data type	● INSERT or UPDATE, which is faster?
● SYBASE: truncation point 问题	● truncate和delete在ORACLE里有什么区别?
● which one is faster? truncate or delete?	● 谁能帮我看看这个sql query的优化

相关话题的讨论汇总
话题: truncate话题: table话题: forever

进入Database版参与讨论

1

(共1页)

m**y 发帖数: 18546	1 一个很简单的truncate statement，平时都很快就能run 完了，今天一直run都不结束。别的 select statement 都没事。可能是什么原因啊？
j*****n 发帖数: 1781	2 other process locked the table... sp_who2 active
m**y 发帖数: 18546	3 谢谢！解决了。确实有个ghost process locked the table 【在 j*****n 的大作中提到】 : other process locked the table... : sp_who2 active

1

(共1页)

进入Database版参与讨论

相关主题
● 谁能帮我看看这个sql query的优化	● Is there any easy way to truncate the LDF file of SQL SERVER?
● 面试回来发考题1	● Access 'memo' data type
● 新手一问，关于delete和truncate table	● SYBASE: truncation point 问题
● 创建数据库问题	● which one is faster? truncate or delete?
● Re: Is there any easy way to truncate the LDF file of SQL SERVER?	● Database Interview Questions
● Oracle求助，thanks!!!	● SQL 2005 Intergration Service Q
● Import data from excel into sql server 2000	● sql server 怎么关掉log
● Truncation error import csv file to SQL table	● delete

相关话题的讨论汇总
话题: truncate话题: table话题: forever

未名新帖统计// 7月16日

#	版面	帖数(主题数)
-	全站	4871 (796)
1	Military	3777 (569)
2	Stock	341 (51)
3	Joke	117 (17)
4	History	116 (3)
5	Automobile	100 (9)
6	USANews	55 (9)
7	Midlife	45 (1)
8	Headline	41 (41)
9	Dreamer	33 (13)
10	FleaMarket	32 (20)
11	Living	30 (7)

* 这里只显示发帖超过25的版面，努力灌水吧:-)