Calculate Table Size and row count
This script calculates table row count and size(MB), as well as the used space and free space.
2014-01-31 (first published: 2014-01-17)
2,152 reads
This script calculates table row count and size(MB), as well as the used space and free space.
2014-01-31 (first published: 2014-01-17)
2,152 reads
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
Hello, so I was reading on partitioning a large table, Which i successfully did,...
Can I authenticate with Active Directory and get into PostgreSQL? Version: PostgreSQL 16.1 on...
USE [DBName] SELECT QUOTENAME(SCHEMA_NAME(sOBJ.schema_id)) + '.' + QUOTENAME(sOBJ.name) AS [TableName] , SUM(sPTN.Rows) AS [RowCount]...