Check FileSize and LogUsage for all DBs
This script provide informations about SQL DBs files size and Log usage.
This little script use os_performance_counters
2015-12-14 (first published: 2015-12-03)
1,524 reads
This script provide informations about SQL DBs files size and Log usage.
This little script use os_performance_counters
2015-12-14 (first published: 2015-12-03)
1,524 reads
When you’re reading from a log shipped secondary, you want the duration of restores to be as short as possible. The sproc provided switches the restores to “NORECOVERY” mode, and then switch back to “STANDBY” at the end of the process.
2015-12-11 (first published: 2015-11-23)
3,194 reads
This will log output of estimate compression for both PAGE and ROW for all tables and indexes
2015-12-10 (first published: 2015-11-20)
2,578 reads
Easy way to get the TLOg space Usage details
2015-12-07 (first published: 2015-11-19)
1,427 reads
This script will check the status of the node in Always On and enable or disable the jobs according to our requirement.
2015-12-02 (first published: 2015-11-18)
1,654 reads
SQL SERVER Includes a Hashbytes function, however it's limited to VARCHAR(8000). This can cause a problem when trying to build hashes over wide datasets.
Solution
Expose the C# Hashbytes function using CLR
2015-12-01 (first published: 2015-11-06)
979 reads
2015-11-26 (first published: 2015-11-02)
9,418 reads
Scripts used to validate the backups information as below
1) Database Backups for all databases For Previous Week
2) Most Recent Database Backup for Each Database
3) Most Recent Database Backup for Each Database - Detailed
4) Databases Missing a Back-Up Within Past 24 Hours
2015-11-25 (first published: 2015-11-03)
1,813 reads
Find Tables with identity, which should have PK with 1 column but have a PK which is clustered but has multiple columns.
2015-11-24 (first published: 2015-11-04)
967 reads
Find Tables with identity, which should have PK with 1 column but have a PK with multiple columns or where the unique identity is contained in other indexes.
2015-11-24 (first published: 2015-11-04)
185 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers