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,670 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
A New Word: Ecstatic Shock
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
Forums
Lessons from the Postmark-MCP Backdoor
Comments posted to this topic are about the item Lessons from the Postmark-MCP Backdoor
Arc Enabled SQL Server
Just saw the "Azure Extension for SQL Server" Does anyone has experience with it?...
Recursive Select - What is this really doing
I've noticed several instances of what looks like a recursive insert with the format:...
Question of the Day
The Maximum Value in the Identity Column
I have a table with this data:
TravelLogID CityID StartDate EndDate 1 1 2025-01-01 2025-01-06 2 2 2025-01-01 2025-01-06 3 3 2025-01-01 2025-01-06 4 4 2025-01-01 2025-01-06 5 5 2025-01-01 2025-01-06I run this code:
SELECT IDENT_CURRENT('TravelLog')
I get the value 5 back. Now I do this:
SET IDENTITY_INSERT dbo.TravelLog ON
INSERT dbo.TravelLog
(
TravelLogID,
CityID,
StartDate,
EndDate
)
VALUES
(25, 5, '2025-09-12', '2025-09-17')
SET IDENTITY_INSERT dbo.TravelLog OFF
I now run this code.
DBCC CHECKIDENT(TravelLog)
GO
INSERT dbo.TravelLog
(
CityID,
StartDate,
EndDate
)
VALUES
(4, '2025-10-14', '2025-10-17')
GO
What is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025?
See possible answers