Do you have index maintenance scheduled, and if so has it run since the last successful full backup?  The reason for the size of your differential is most likely that...

You mean remote in that none of them communicate with any of the others?  In that case, yes, you'll need to deploy individually.  You can either develop a package for...

Paul

Yes, if you're going to deploy each individual package on the server that hosts the database it connects to.  But you might consider instead putting all the packages...

The database to which you connect from a package isn't important.  All that you need to make sure is that the network library you use to connect to SQL Server...

Is it because a comes before A and therefore [A-G] doesn't include a?

John

It's not at all clear what you're trying to achieve, but something like this may work:SELECT
    COUNT(CASE
            WHEN pr.Due != 0 THEN 1
        END) [halfpaid]
,    COUNT(CASE
            WHEN pr.delivered...

Yes, well done - I imagine that's what they were looking for.  And I even learned something myself - I didn't realise you could use NULL instead of...

You can edit the properties of the constraint to change it to an OR instead of an AND (at least you can in SSIS, and a Maintenance Plan is just...

Your Check Database Integrity Task is waiting for the History Cleanup Task and the Notify Operator Task to complete.  But NOT will only be invoked if BUDT fails, which is...

Yes, I understand what the requirement is.  You asked for help to answer the questions.  I'm not answering them for you - that would defeat the purpose of their existence.

Are you saying that the vendor's code uses the first query, but you want to persuade them to use something like the second query?

When you say the second...

(1) Use a ROW_NUMBER() clause to number the rows so that the row you wish to keep (or wish to delete) in each partition is numbered 1.  Then write your...