I am pretty sure that the problem is with that buffer pool size as the error indicated.  The error is saying that the connection was closed by the remote host. ...

I believe the reason it is skipped is because the next restore step MAY include the steps that the undo phase would have undone.  If you use NORECOVERY, SQL is...

The master key password is used to decrypt the master key.  If you change the password AND you are decrypting it by password (as opposed to decrypting by the service...

looking at it, to me it appears that it is slow because you are looking at a LOT of data to review and then update a single row.  Mind you...

An alternate, but similar, approach would be to add a sequential integer column to the table rather than the row_number approach.  This should have better SELECT performance than row_number() at...

What I am seeing is it failed validation.  If I remember right, failed validation is thrown when metadata changed.  So you will need to edit the SSIS package to update...

Grow TEMPDB is another step where possible.  I try to ensure I have enough disk space to allow for autogrowth and I try to monitor for abnormal autogrowth on all...

For the database itself, our naming convention is to either name it after the application that uses it, or if multiple applications are using it, then the processes that are...

"best" standards really depend on your environment and how often objects will change and how your team works.

For example, I like naming my tables with the name of the entity...

My approach would be to get this working in TSQL then put the TSQL into SSIS as your source.

My approach (likely not the most efficient) would be to do it...

• This reply was modified 3 years, 12 months ago by Mr. Brian Gale.

Alternately, you could use windowing functions to sum the decals column like:

SUM(decals) OVER (PARTITION BY a.FSTRJURISDICTION, d.fstrFormattedID, inv.flngNumItems, ar.fstrStreet, lic.fstrStatus, a.fstrFuelType)

Not ideal as you will get 1...

I do not know a lot about Azure data factory, but looking at the screenshots, it LOOKS to me like you are only pulling 1 column from ParquetSource.  When you...

One other thing to look at would be bandwidth.  On-Prem, you may have a Gb ethernet connection between you and the server.  In the cloud, you may have reduced bandwidth.

As...

First, welcome to the SQL Server forum... next, you posted this in the wrong section.  You are not running SQL Server 2019, you are running MariaDB.

I would recommend looking up...

I think the easiest way to fix a "log file full" is to increase the size of the log file, but that assumes you have disk to do so.

When you...