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:

            
June 17, 2022 at 7:54 pm
            
#4051144

            
            
                                                
        

FYI - your offsets are incorrect here.  Eastern Time is currently set to -04:00 and Central European (summer time) is set to +02:00.  The expected output you have is correct...

I would recommend working with the receivers of the data to allow sending UTC directly instead of trying to perform the conversion for them.  If you send UTC they can...

To be able to determine the week number - you need to know 2 things.  You need to know the start of the year and the end of the year...

#3 in your recommendations is incorrect.  If your database is set to full or bulk-logged recovery models - you absolutely need to be running frequent transaction log backups.

If you are...