Duplicate post.  Please... no posts here.  No need to split up possible answers.  Go to the first one in process at https://www.sqlservercentral.com/forums/topic/audit-failed-successful-login-log-4#post-3709164

Yes!

With database designs that would make Codd break down weeping. They...

I've not worked with Dynamics... is that one of those MS applications/databases that uses random GUIDs for keys?

Two way street here... what solution did you come up with?

In that case, use a non-clustered index on the hashkey.  It will be more narrow than a clustered index and will run much more quickly.

Hmmm... wait for it...

Hmmm... maybe an "Instead-of" trigger to reject DELETEs?

An alternative solution

;WITH cte AS
(
    SELECT s.Teams, s.Category, SUM(s.Sales) Sales
      FROM dbo.Sales s
   ...

I agree with Jeff Williams... contact the vendor for this information but be careful and don't hold your breath.  They either won't have it or will be loath to part...

I a m developer (SSAS/SSIS) and familiar with the concepts of clusted and nonclustered indexes.

How much more about indexing/statistics/... should i have knowledge of?

What is "nice to have" and...

Disclaimer:  I don't use Ola's good code nor do I use "AG" (we use something else at work).

I understand that you currently have a single job but it would appear...

Just be careful not to over-provision the number of files in TempDB.  The "standard" recommendation is 1 file per core up to 8 as a start and then tune from...

+1 Million for that suggestion.

Also, do you have a proc that properly maintains statistics and (to a lesser extent) fragmented...

Ummm... call Ola's stuff differently for specific databases?

Several.  In our normal course of business, we do periodic restores, and I request periodic restores just to make sure they're working correctly.  This particular company has done extremely...