If you need to find previous posts - go to your profile and select 'Topics Started'.  Review the previous thread - @JeffModen provided a similar template with additional options for...

Is this a repeat of this question: https://www.sqlservercentral.com/forums/topic/large-table-cleanup-using-delete

Why start up a new conversation for something where you accepted an answer?

Because BatchDate is a string formatted as MMDDYY and you are trying to compare that to another string formatted as MM/DD/YYYY.  What you are expecting is that BatchDate in the...

The backup to URL functionality was introduced in SQL Server 2012 - what appears to be different is the methodology.

It appears that for 2014 and prior you need to specify...

Have you review this article: https://docs.microsoft.com/en-us/previous-versions/sql/2014/relational-databases/backup-restore/sql-server-backup-to-url?view=sql-server-2014

It appears that 2014 and prior versions require a different setup and configuration for backing up to Azure blob storage.

As was noted before - using both DISTINCT and GROUP BY in the same query is meaningless.  A GROUP BY will return distinct rows based on the defined grouping -...

So I will ask again...

I would say it depends on the type of report you are going to create - if it fits in with a general tabular or matrix type report, then using...

What did you set the backup preference as for that availability group?

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-backup-on-availability-replicas-sql-server?view=sql-server-ver15

The maintenance plan should contain logic that uses that preference to determine where to perform the backups.  It is...

Regardless of VM or physical - there is a performance advantage that can be realized when every data file for a database is on a separate drive.  There is a...

I have a couple of questions:

1. Why do you need a new table created for each file - every time?  Could this be done into a single table for each...

I would suggest putting all of the logic in the one procedure - instead of separate steps in an agent job.  Start a transaction, perform your insert and delete in...

A possible solution would be to unpivot the KEN_N# columns and use a string splitter on a delimited input parameter.  This would allow for identifying not only the row that...

You should not stop the default trace - it isn't something that affects user databases or has any impact on an AG.  It allows for tracking changes to the system...

You can reference a...