摘要:
返回表名、索引名和行数SELECT object_name(i.object_id) as objectName, i.[name] as indexName, sum(p.rows) as rowCntFROM sys.indexes iINNER JOIN sys.partitions pON i.object_id = p.object_idAND i.index_id = p.index_idWHERE i.object_id = object_id('dbo.Meeting')AND i.index_id = 1GROUP BY i.object_id, i.index_id, i 阅读全文
posted @ 2010-12-20 14:47
zping
阅读(1697)
评论(0)
推荐(0)
浙公网安备 33010602011771号