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,313 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)
802 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,018 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,082 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,882 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,522 reads
2019-11-01 (first published: 2019-10-19)
6,782 reads
2019-11-01 (first published: 2019-10-22)
453 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
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Forums
Alamat kantor BCA KCU DARMO Telp:082144477715
Wa:0821-4447-7715 PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
ALAMAT KONTAK BCA KCP Katamso Telp:08218154393
WA:08218154393 Jl. Brigjen Katamso No.183, Keparakan, Kec. Mergangsan, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55121
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers