2016-07-04 (first published: 2016-06-08)
881 reads
Table Size
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,681 reads
Easily calculate the size of your tables
This quick and dirty sql will tell you the number of rows in your tables, the size in MB of yout data, and the total size (including indexes)
2009-05-05 (first published: 2008-10-04)
1,668 reads
Tables, Queues, and Indices as a Percent of DB Size
Two views that give you a variety of stats, sortable as a percent of DB size, for tables, indiceses, XML indices, and Service Broker Queues.
2012-10-09 (first published: 2008-06-16)
3,075 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Setiabudi Atrium Telpon/WA:08137887595
BCA KCP Setiabudi Atrium Telpon/WA:08137887595.Setiabudi Atrium, Plaza Setiabudi, Jl. H. R. Rasuna Said No.Kave...
BCA KCP Mangga Dua Square Tlpn/Wa 0853.7373.7551
Mangga Dua Square, Komp. Ruko, Jl. Gn. Sahari Blok G No. 8-9, Daerah Khusus...
BCA KCP Manhattan Telpon/WA:08137887595
BCA KCP Manhattan Telpon/WA:08137887595.The Manhattan Square, Mid. Tower, Lt. Ground Unit A & Lt....
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers