Using JSON for matrices in SQL Server.

From SQL Server 2017, it becomes more practical to use JSON arrays for representing and processing a matrix. SQL Server can read them, and update values in them but...

Finding a character in every character string by elimination

Using a number’s table, you can break down every value in a column into one character per row, and then do some analysis. In our case, I want to find a bad character, by eliminating known acceptable characters.

Getting the columns

Filling Missing ID Codes In SQL

This is going to be a bit of a brain storming post that comes from an interesting question that I was asked today: “I’ve got a table with a ID code field, now some of the rows have a value in that field and some are NULL. How can I go about filling in ...

Installation of SQL Server client tools

It is the fourth post on series related to installation and configuration of SQL Server client tools required. This series is for professionals who start their journey with SQL Server administration and also for those who want to extend and structure...

How Does QUOTED_IDENTIFIER Works in SQL Server? – Interview Question of the Week #217

Question: How Does QUOTED_IDENTIFIER Works in SQL Server?
Answer: If you search on the internet, you may find quite lots of notes about it. So this blog post, explains it in very simple words.

Replacing SQL Cursors with Alternatives to Avoid Performance Issues

In this article, we’ll look at some alternatives to using SQL cursors which can help to avoid performance issues caused by using cursors.

T-SQL correlated queries

The Performance of Window Aggregates Revisited with SQL Server 2019

T-SQL window functions have been a fantastic addition to the T-SQL language. In this article, Kathi Kellenberger reviews how optimizations available in SQL Server 2019 can improve the performance of these functions.

Using T-SQL to find the Greatest Common Divisor (GCD) for any number of integers

In this tip we look at T-SQL code that can be used to determine the greatest common divisor for a set of integers.