Articles

Technical Article

Upgrade and Migrate SSIS Catalog and SSISDB to a New Server

There will come as time when you need to upgrade the host operating system and SQL Server to a newer version. If you are using SQL Server Integration Services (SSIS), one of the things you may need to do is to move the SSIS catalog (SSISDB database) to the new server. We will cover the steps in this tutorial to migrate the SSISDB from one server to another.

You rated this post out of 5. Change rating

2025-02-21

Blogs

Eliminating Unnecessary DELETE Operations

By

SQL Server performance issues often stem from easy fix bottle necks that can be...

T-SQL Tuesday #183: Improving Permission Management

By

This is my (late) answer to my own invitation for T-SQL Tuesday #183. I...

Enterprise Digital Exhaust

By

Digital exhaust, or data exhaust, is the information you generate as you interact digitally....

Read the latest Blogs

Forums

Perfomance in views

By rusbel.rubio

Hello, I want to ask you about the following case that I live with...

How to Download and Restore AdventureWorks 2022 Database

By Noman072

Comments posted to this topic are about the item How to Download and Restore...

Your Biggest Data Model Complaints

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Your Biggest Data Model Complaints

Visit the forum

Question of the Day

Rows estimation with OPENJSON

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