Are you saying you cannot get a static IP address assigned to a server?  It doesn't matter whether or not the server is virtual or physical - you should be...

What is the reasoning behind adding additional tempdb files?  Is there an issue you are trying to resolve - and have identified that issue as being related to tempdb?

If the...

Secondary Replica 2 (same location Sync mode for fail over) -  Allow some users to do select queries so no one should run any queries in Primary, would this...

This is essentially the same as Frederico's first option:

Declare @startDate date = (Select max(co.EntryDate)
             ...

No - you cannot setup an availability group between versions like this and you cannot make the databases read/write on the secondaries.  At best you can make the databases read-only...

You should review this article: http://www.sommarskog.se/grantperm.html

There are several options available for EXECUTE AS - but to be safe I would recommend using a certificate and signing your procedures with that...

Litespeed executes from an extended procedure - which creates a new connection to the database to perform the backup.  By default, the service account running SQL Server Agent does not...

No - there isn't a way to make Visual Studio work the same as Report Builder...and you really don't want to do that.  The benefit of using SSDT is that...

Actually, this makes perfect sense to me. The CreationTime is a property of the $directory object. In the quoted string, $directory.CreationTime cannot be determined because the parser doesn't recognize...

Use CONCAT instead of the plus sign - CONCAT will take care of converting to the appropriate data type for you.

, CONCAT(a.sku, p1.SHORT_DESC, ' ', p1.LONG_DESC1) AS short_description

            
January 2, 2020 at 7:05 pm
            
#3711942

            
            
                                                
        

I would recommend using CONCAT instead of the plus sign...it will simplify the code:

CONCAT(master_id, company_code, FileLocation_FileBeginsWith, despatch_group
     , convert(char(8), isnull(despatch_group_start_date, '19000101'), 112)
 ...

For an INNER join there is no difference - and you can validate that by viewing the execution plan generated from each statement.

 

How are you stopping/starting SQL Server Agent - and why is that something that needs to be done on a regular basis?

If you are using the services applet to stop/start...

You just need BEGIN/END around the statement.

Also, it will be more efficient to use EXISTS than SELECT COUNT(*).

IF EXISTS(SELECT * FROM [A]) BEGIN

   ...

You need to use something like this: ' + convert(varchar(85), Sid, 1) + '

You don't convert to a varbinary and then concatenate to a string - you need to convert...