Log Shipping doesn't mean you don't have access to those log backup files. It's just a different agent that manages them.

If you use Ola Hallengren SQL Server Backup, the...

Only if you restore the full backup with no recovery (i.e., the database to which you restored is in restoring mode).

No. A differential backup is just what the name implies. It is used to restored changes to the full backup. You can't restore the diff w/o first restoring the full.

If you know the dates are always in DD/MM/YYYY format, perhaps you could pre-swap the month and day segments of the string & avoid the need to set dateformat --...

If you know the dates are always in DD/MM/YYYY format, perhaps you could pre-swap the month and day segments of the string -- e.g.,

DECLARE @DateString CHAR(10) =...

See https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-1-converting-rows-to-columns-1 & https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-2-dynamic-cross-tabs

Seems related to your other question: https://www.sqlservercentral.com/forums/topic/assigned-as-guest-when-installed-sql-server-on-workstation.

If his windows login has sysadmin permissions, then yes. If not, then somebody (e.g., IT) has to login as sa to create users &...

frederico_fonseca wrote:

do not use the native string_split - slow and does not return the ordinal of the strings.

Aaron Bertrand's tests from 2016 showed exceptionally good performance: https://sqlperformance.com/2016/03/sql-server-2016/string-split

Might have been appropriate for Halloween.

Always exclude SQL Server data, backup, & repl folders from antivirus scans -- they are well known to be devastating to performance. Many people have experienced this -- it's just...

You don't know the delimiter? It's not predefined/standardized?

STRING_SPLIT function is available in 2016, but would require nvarchar instead of ntext.

ntext has been deprecated since SQL Server 2008, & has limitations...

Good question, homebrew01.

roland:

Recovery model? Full? Simple? Bulk-logged?

I assume we're talking about full backups. How often?

If full, how often are you doing log backups? Are they succeeding?

Is backup the only thing happening at that time? Is there index maintenance or CHECKDB going on in the same job (or worse, simultaneously)?

What do you mean by "own backup...

A non-clustered index may help.

In most cases, you should probably have a clustered index.

SSMS can tell you dependencies for the procedure as a whole.

At the CTE level, as far as I know, that will require a diligent data engineer.

Be alert to the use...