kk Blog —— 通用基础


date [-d @int|str] [+%s|"+%F %T"]
netstat -ltunp
sar -n DEV 1

SQL Server查看所有表大小,所占空间

https://blog.csdn.net/sinat_38380922/article/details/82017579

1
2
exec sp_spaceused '表名'    # 表占用空间
exec sp_spaceused           # 数据库所有空间
1
SELECT top 30 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

tools, sqlserver

« CentOS7 yum alert 弹窗去掉上方 title 网址域名 »