Please post table definitions, index definitions and execution plan.

A balanced tree is always balanced, that's part of the definition of the data structure. It cannot be unbalanced.

First line in the answer:

The limit for us humans is 2TB, but SQL stores the...

Straight from Books Online:

[ @recipients= ] 'recipients'

...

Select from sys.dm_exec_requests cross apply to sys.dm_exec_sql_text.

DO: Test first. Hekaton is not an automatic silver bullet for performance problems. You may get no gain, you may get a reduction in performance. If you don't have good...

Probably not. If the very small overhead of requesting locks is noticeable, you probably have other problems.

If you really want, mark the DB read only in its entirety, then SQL...

The problem with the ESP network is the signal:noise...

The procedure does have parameters, because the error is referring to sp_send_dbmail. The bolded line is the problem

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'SystemAlerts',

@from_address = 'DBAlerts@blake.co.za',

@recipients = 'Dlozi.Nzuke@interactivesa.co.za', 'nivashan.govender@interactivesa.co.za',

@query = 'exec SP, Sp_Compare_Acc_Comment'...

There's really not enough information here. To evaluate hardware, I'd normally do a full week (or more) analysis on wait stats and perfmon counters (lots of them) at the least.

😀 And so it begins...

Plenty wrong. For starters, this

where cast(convert(varchar(10),PostingDate,110) as datetime) between cast(convert(varchar(10),@YearStartDate,110) as datetime) and cast(convert(varchar(10),@YearEndDate,110) as datetime)

Change that so that you have no functions of any form on the columns. Hint,...

SELECT UserID FROM UserColor GROUP BY UserID HAVING COUNT(*) = (SELECT COUNT(*) FROM Color);

Every backup to its own separate file.

Appending backups to the same file doesn't mean you can restore them all in one single operation, you'd still have to run the RESTORE...

Can you post that specific select into please? The entire statement.