Compression estimates
The script estimate compression benefits per each object in the database for which the page compression has not been implemented.
2018-02-15 (first published: 2018-01-15)
2,028 reads
The script estimate compression benefits per each object in the database for which the page compression has not been implemented.
2018-02-15 (first published: 2018-01-15)
2,028 reads
2018-02-12 (first published: 2018-01-24)
320 reads
2018-01-26 (first published: 2018-01-18)
12,161 reads
During a database migration or a side by side database upgrade project we need to migrate the MS SQL Server Agent jobs. This script compare jobs by names and shows unmatched jobs.
2018-01-25 (first published: 2018-01-20)
3,361 reads
Often we need to know on which stage is a maintenance operation such as: backup, restore, check database. You can get this information using my script.
2018-01-17 (first published: 2018-01-12)
616 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Can/Can't Do/Don't
Comments posted to this topic are about the item Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers