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...
2019-04-09
T-SQL
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.
2019-04-05
2019-04-05
1,671 reads
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 ...
2019-03-30
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...
2019-03-30
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.
2019-03-30
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.
2019-03-30
2019-03-14
973 reads
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.
2019-03-07
2,782 reads
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.
2019-01-16
2,635 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Using OPENJSON
Comments posted to this topic are about the item Using OPENJSON
Data Modeling with dbt for Visual Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Data Modeling with dbt for...
Question of the Day
Using OPENJSON
I have some data in a table that looks like this:
BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beerIf I run this, what is returned?
select t1.key
from openjson((select t.* FROM Beer AS t for json path)) t1 See possible answers