Sorry, but nothing matched your search terms. Please try again with some different keywords.
SQL Server performance issues often stem from easy fix bottle necks that can be...
By Steve Jones
This is my (late) answer to my own invitation for T-SQL Tuesday #183. I...
By Brian Kelley
Digital exhaust, or data exhaust, is the information you generate as you interact digitally....
Hello, I want to ask you about the following case that I live with...
Comments posted to this topic are about the item How to Download and Restore...
Comments posted to this topic are about the item Your Biggest Data Model Complaints
Consider the following script for a Sql Server database with Compatibility Level at least 130 (Sql Server 2016):
create table tjson ( id int primary key, j1 varchar(max), j2 varchar(max), j3 varchar(max)); insert into tjson (id, j1, j2, j3) values (1, '[{"c11":"value11A", "c12":"value12A"},{"c11":"value11B", "c12":"value12B"}]', '[{"c21":"value21A", "c22":"value22A"},{"c21":"value21B", "c22":"value22B"}]', '[{"c31":"value31A", "c32":"value32A"},{"c31":"value31B", "c32":"value32B"}]');How many rows does the Query Optimizer estimate for the following query?
select id, c1.c11, c2.c21, c2.c22, c3.c31, c3.c32 from tjson cross apply openjson(j1) with( c11 varchar(50) '$.c11', c12 varchar(50) '$.c12') c1 cross apply openjson(j2) with( c21 varchar(50) '$.c21', c22 varchar(50) '$.c22') c2 cross apply openjson(j3) with( c31 varchar(50) '$.c31', c32 varchar(50) '$.c32') c3;See possible answers