2016-07-04 (first published: 2016-06-08)
768 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)
1,923 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-04 (first published: 2008-10-04)
1,634 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,040 reads
Blogs
ACM Lecture at SELU
By Will Assaf
Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at...
T-SQL Copy & Paste Pattern – Increasing a performance problem
By Cludio-Silva
Disclaimer: The title is my assumption because I saw it in the past happening...
Removing ad hoc plans from Query Store
By DesertDBA
This is not a post about the “optimize for ad hoc workloads” setting on...
Forums
Needed to find all possible Dates Overlaps from a single Table
Hi, I have the following Episode table example: Where DischDate = "2020-02-20" means - client hasn't...
Optimize Cursor
I inherited this script that has a cursor and I know this query can...
Unable to add secondary node existing node due to DCOM is unavaialble
Dear Team, This is Naveen, Hope all are doing well. I need emergency help...
Ask SSC