Why do you want to use a cursor to do this.

Think SET !

you are using 3part naming to address the new matchcode object, remove "USE [test]" before statement INSERT INTO...

• This reply was modified 4 years, 2 months ago by Johan Bijnens.

Spot on! (no matter the chosen technology)

Alternatively have a look at "Get packages from SSIS Catalog"

it uses Powershell to download the packages

You should have removed...

check: "Checklist: Best practices for SQL Server on Azure VMs"

Does the service account of the target server ( 2016 ) have read authority for the backup file ?

There is something fishy with the question:

1. Are you really going to mix all Item types in this comparison?
2. How could you handle equal itemcount rows for a given country?

Spot on, Jeff !

The main point for people to prefer varchar over char is that their GUI development tool doesn't have to bother with trailing spaces.

Sorry, Steve, I clicked "report" in stead of quote 🙁

Closing a post after 1 year of no responses seems fair to me.

That is normal, as tempdb will always have the same startup size per file on a given setup and will grow as needed.

I don't think we can configure its size...

xEvents are your friend !

Have a look in the attached scripts file on how I monitor hand handle failovers ....

et voila .... they already fixed it 🙂

You can get all backup / restore history from msdb database!

have a look at ....

select  BU.server_name
      , BU.machine_name
   ...

DBATools.io has a nice function called Find-DbaDbDuplicateIndex (however it has IMHO aflaw and does not report IsUnique for an index, reporting duplicate indexes composed of...

IMHO: No

It should be set to support the workload of the instance: "Why Cost Threshold For Parallelism Shouldn’t Be Set To 5"