Table Size Script Update for 2015
As was recently promised, I have an update to an old tried and true script for calculating the size of...
2015-08-04
1,052 reads
SQL RNNR
Table Size Script Update for 2015
Newest update to the script to help discover and track object sizes within a database.
Related Posts:
Refresh SQL Modules November 9, 2018
Drop That Schema October 27, 2017
An Experiment...
2015-08-04
2 reads
Internal Tables and Space Used
Some of the beauty of SQL Server is the complexity that it holds. Some of that complexity is right before...
2015-07-30
2,677 reads
Internal Tables and Space Used
Some of the beauty of SQL Server is the complexity that it holds. Some of that complexity is right before our eyes. And some of that requires a little...
2015-07-30
5 reads
What’s the Size of that Index?
I have previously written about finding what the big space consumers are within the database. I even shared scripts in...
2015-08-04 (first published: 2015-07-27)
2,305 reads
What’s the Size of that Index?
When you need to figure out how indexes are contributing to the overall size of a table within a database, this script will help you!
Related Posts:
Ghosts in your Database...
2015-07-27
2 reads
Extended Events Removed from 2016
SQL Server 2016 is on the horizon. We have a few CTP versions already released for download, allowing people to...
2015-07-22
665 reads
Extended Events Removed from 2016
Extended Events continue to grow and improve - even with the removal of a few events.
Related Posts:
Upgrading From SQL Server Profiler December 26, 2018
Correlate SQL Trace and Actions...
2015-07-22
6 reads
TSQL Recipes – 2014 Edition
Announcing…the book
At long last the wait is over. After much blood, sweat and more blood and sweat, the next edition...
2015-07-21
538 reads
TSQL Recipes – 2014 Edition
Announcing…the book At long last the wait is over. After much blood, sweat and more blood and sweat, the next edition of the SQL Server Recipes book is finished....
2015-07-21
1 reads
Blogs
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
The Book of Redgate: What Our Customers Say
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers