tag:blogger.com,1999:blog-10940209.post4401070466193290253..comments2023-11-04T10:39:41.621+08:00Comments on 鳥毅的Blog: 找出SQLServe某個Database裏每個table的使用量鳥毅http://www.blogger.com/profile/08368762184448456724noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-10940209.post-77735360941131929872009-11-27T08:10:31.466+08:002009-11-27T08:10:31.466+08:00非常感謝 evi1[c] ,您的版本快速精簡,實在是太優秀了。非常感謝 evi1[c] ,您的版本快速精簡,實在是太優秀了。鳥毅https://www.blogger.com/profile/08368762184448456724noreply@blogger.comtag:blogger.com,1999:blog-10940209.post-14117156947007785042009-11-26T19:55:30.505+08:002009-11-26T19:55:30.505+08:00找所有 table 筆數的方式有個很快的方法, 我是拿來對付一個月會生出兩三千萬筆資料的 table...找所有 table 筆數的方式有個很快的方法, 我是拿來對付一個月會生出兩三千萬筆資料的 table。參考一下:<br /><br />SELECT sysobjects.[name], max(sysindexes.[rows]) AS TableRows, <br /> CAST( <br /> CASE max(sysindexes.[rows]) <br /> WHEN 0 THEN -0 <br /> ELSE LOG10(max(sysindexes.[rows])) <br /> END <br /> AS NUMERIC(5,2)) <br /> AS L10_TableRows <br />FROM sysindexes INNER JOIN sysobjects ON sysindexes.[id] = sysobjects.evi1[c]https://www.blogger.com/profile/01780158865011180045noreply@blogger.com