Estimate compression for all tables and indexes with both Row and Page
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,524 reads
Scripts
Getting transaction log space usage statistics for all databases.
Easy way to get the TLOg space Usage details
2015-12-07 (first published: 2015-11-19)
1,407 reads
SQL Jobs on Always On
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,640 reads
HashBytes Nvarchar(MAX)
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)
960 reads
2015-11-26 (first published: 2015-11-02)
9,273 reads
Database Backup Information Scripts
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,780 reads
Design Errors : PK's with multiple columns on table with identity
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)
952 reads
Design Errors : PK's with multiple columns on table with identity
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)
163 reads
Figure out recovery mode for each database
It is anoying that someone created a new database and left its recovery mode in simple and it caused your backup jobs to fail.
2015-11-23 (first published: 2015-10-26)
681 reads
Temporary exclusive database access
This simple script disconnects any other session that is connected to the specified database by temporarily switching the database to single user.
2015-11-20 (first published: 2015-10-25)
953 reads
Blogs
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
Forums
Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers