sqlserver常用查询
-----查询所有表和行数
SELECT a.name, b.rows
FROM sysobjects AS a INNER JOIN sysindexes AS b ON a.id = b.id
WHERE (a.type = 'u') AND (b.indid IN (0, 1))
ORDER BY b.rows DESC
---单表更新更新统计信息 100万行大概25秒
UPDATE STATISTICS dbo.表名 WITH FULLSCAN
-----查询所有表和行数
SELECT a.name, b.rows
FROM sysobjects AS a INNER JOIN sysindexes AS b ON a.id = b.id
WHERE (a.type = 'u') AND (b.indid IN (0, 1))
ORDER BY b.rows DESC
---单表更新更新统计信息 100万行大概25秒
UPDATE STATISTICS dbo.表名 WITH FULLSCAN
