A varchar(MAX) STRING_SPLIT function for SQL 2012 and above
An alternative for Microsoft's STRING_SPLIT function that will work on SQL Server 2012 and higher.
2019-12-05 (first published: 2019-02-28)
26,288 reads
Scripts
Function and Queries to Convert Hierarchical Adjacency to Nested Json Arrays
This script converts hierarchical adjacency into nested json rows which contain the recursive "downlines" of each node. The table-valued function treats each row in the original adjacency as the root node in a recursive common table expression.
2019-11-25 (first published: 2019-11-24)
799 reads
Create a view to Alter a Table and Add three Columns
I am teaching a database class at Queens College. The project entails the truncation of all of the data and loading new data into the existing database "BIClass" from a single of the flattened data. One of the tasks of the project was to add these three additional columns to each of the tables (AlterTableAddColumnsUserAuthorizationKeyAndTwoTimeStamps): […]
2019-11-18 (first published: 2019-11-10)
1,017 reads
Function and Queries to Convert Hierarchical Adjacency to Nested Json Arrays
This script converts hierarchical adjacency into nested json rows which contain the recursive "downlines" of each node. The table-valued function treats each row in the original adjacency as the root node in a recursive common table expression.
2019-11-12 (first published: 2019-11-08)
2,081 reads
T-SQL query to get the latest available backup chain
T-SQL query to return the latest available database backup chain (Full, Differential and Log) of individual databases along with their backup size and compressed size.
2019-11-08 (first published: 2019-10-30)
3,875 reads
sp_PerfSQ
A diagnostic tool for identifying Performance features of active SQL Queries. It collects performance detail from DMVs for queries with executing requests and is designed to demonstrate and quantify Query Shaping optimisation techniques by: quantifying query workload and throughput characteristics providing behavioural descriptors of potential performance inhibitors - refer column ThrottlePotential The ThrottlePotential column is […]
2019-11-07
4,185 reads
T-SQL query to copy data from one database to another database
T-SQL query to copy the rows of all the tables from one database to another database only if they have rows in Source DB and exact same Schema in both Source and Destination DB.
2019-11-07 (first published: 2019-10-30)
5,519 reads
2019-11-01 (first published: 2019-10-22)
452 reads
2019-11-01 (first published: 2019-10-19)
6,773 reads
Function to pad Bigint with leading zeros or other single characters
Function to pad bigint with leading 0's or other single character
2019-10-31 (first published: 2019-10-23)
770 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Backup Availability Group
Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers