Do you have monitoring history to support such a report?

There is no simple correlation between hardware required and number of rows, gigabytes of data, or number of users, for example.

You...

You need to truncate the time to the hour --e.g.,

dateadd(hour, datediff(hour, 0, convert(TT.horas, Time) ), 0)

You can then do whatever aggregation or calculations are required.

Yes, they are in the log chain -- they use native backup, and are not copy-only. Look in the log-shipping configuration to see where the log backups are stored on/for...

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?