SSMS查看表行数以及使用空间 How to show table row count and space used in SSMS - SSMS Tutorials
2024-09-04 12:38:08
原文:How to show table row count and space used in SSMS - SSMS Tutorials
There's a quick and convenient way to see row count, data and index space used in of all tables in one list with SSMS.
First, go to View and Object Explorer Details or press F7 key to enable Object Explorer Details pane.
Now select Tables item under the database you want to analyze in Object Explorer. List of all tables will show in Object Explorer Details pane on the right. Right click grid header and select:
- Data Space Used (KB)
- Index Space Used (KB)
- Row Count
This will add new columns with those details to the list of your tables.
You can copy this data for further analysis and reporting.
最新文章
- C#调用Couchbase中的Memcached缓存
- 深入Java事务的原理与应用
- squid 学习笔记
- CF577B Modulo Sum 好题
- 从数组中随机取n条不重复的数据
- spm使用之三spm应用实例
- HDU 3533 Escape(bfs)
- windows下设置/删除Tomcat的开机自启动
- 【卷一】正则一 之re.split
- BZOJ 2024: [SHOI2009] 舞会 [容斥原理 高精度]
- vuex 收藏一个循序渐进,易懂易行的博客。
- Android SharedPreferences增,删,查操作
- 在浏览器上安装 Vue Devtools工具
- C#的Struct
- Dubbo的容错与负载均衡
- Java并发(十一):Condition条件
- Caliburn.Micro 项目文档(翻译):Screens, Conductors and Composition
- AWS系列-修改RDS时间(time_zone)
- SVM-支持向量机原理详解与实践
- leetcode216