Database File Growth Report Script
A T-SQL script to track and monitor the growth of your SQL Server Databases.
2025年09月12日 (first published: 2025年09月04日)
312 reads
A T-SQL script to track and monitor the growth of your SQL Server Databases.
2025年09月12日 (first published: 2025年09月04日)
312 reads
This script will help DBAs to find inefficient indexes and duplicate indexes, by providing the following metrics: usage statistics, fragmentation levels, size, and index duplication analysis.
2025年09月10日 (first published: 2025年06月27日)
290 reads
This script loops through all user databases, skips system DBs and any you want to exclude, and enables CDC if it’s not already enabled.
2025年09月05日 (first published: 2025年08月25日)
428 reads
This script automatically generates comprehensive schema documentation that can be easily consumed by AI services for natural language querying, automated report generation, and intelligent data analysis.
2025年09月03日 (first published: 2025年08月25日)
753 reads
COALESCE smartly helps to concatenating the multiple rows value into one cell.
2025年09月01日 (first published: 2025年08月25日)
1,465 reads
Two PowerShell scripts to create backup folders and clean up old files.
2025年08月29日 (first published: 2025年08月16日)
207 reads
This script produces scripts for all the stored procedures in a database.
2025年06月18日 (first published: 2025年06月13日)
790 reads
Semantic versioning (SemVer) is a standardized system for labeling software releases using a three-part number—major, minor, and patch—optionally followed by pre-release labels and build metadata. Comparing semantic versions is complex because it requires handling both numeric and string components, as well as special precedence rules for pre-releases and stable versions. SQL Server’s hierarchyid data type is ideally suited for comparing the numeric parts of semantic versions, enabling efficient and accurate ordering without the pitfalls of string comparison or manual parsing.
2025年05月27日
170 reads
This script will help to find orphan users on all databases and will remove them.
2025年05月20日
252 reads
Get the last six months of growth for a database
2025年05月06日
538 reads
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
Comments posted to this topic are about the item Lessons from the Postmark-MCP Backdoor
Just saw the "Azure Extension for SQL Server" Does anyone has experience with it?...
I've noticed several instances of what looks like a recursive insert with the format:...
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月06日I 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 OFFI now run this code.
DBCC CHECKIDENT(TravelLog) GO INSERT dbo.TravelLog ( CityID, StartDate, EndDate ) VALUES (4, '2025-10-14', '2025-10-17') GOWhat is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025? See possible answers