Consider, for example, with design #1, a unique constraint will insure that the same course is not entered twice for the same year.

But for design #2, you'd have to...

I am assuming you already have the code available to determine which node is primary and which nodes are secondary.  To drop the database on a secondary from a process...

A quick google search shows that the AppVManagement and AppVReporting databases are part of Application Virtualization (https://docs.microsoft.com/en-us/microsoft-desktop-optimization-pack/appv-v5/).

Guessing here - but the db_service and xm_service database appear to be related to...

I'm so sorry, but i can't merge these 3 columns: the recent column and 2 more...

dbo.CabecDoc.Serie + '-' + Company + '-' + dbo.LinhasDoc.CCustoCBL AS JoinCC

I've tried so many...

I recommend starting here: https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-1-converting-rows-to-columns-1

Then follow up with the second article here: https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-2-dynamic-cross-tabs

Instead of trying to use the PIVOT operator you can use a simple GROUP BY with conditional aggregates...

Instead of using an INSERT then DELETE for this process - you can use DELETE ... OUTPUT instead.  This deletes the data from the main table and outputs what has...

Thanks for the reply. This was SSISDB so not sure why tlog where setup initially. I feel there is no need to apply .trn's as this is not transaction...

If you really want faster backup/restore options - then you really need to work with your SAN vendor.  Almost all of them have snapshot capabilities which can perform...

Not clear on your question - if you don't have instant initialization enabled then every data growth will take a long time.  And that setting at any percentage value is...

In addition to what Jeff Moden has outlined - take a look at the BUFFERCOUNT and MAXTRANSFERSIZE parameters for both backup and restore.  Adjusting those values can improve performance quite...

It looks like you want the results from the first table when they don't match.  For this specific case I would use EXCEPT instead of joining and comparing:

Jeffrey Williams

“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll
How to post questions to get better answers faster

Managing Transaction Logs