SQL yes you can limit which cores it uses but can you do that in the other applications your running in the server.

If one of those applications maxes out a...

No the application can use all 8 cores unless you can set some form of affinity in the application.

so if the app maxes out cpu0 then that’s 1 less cpu...

If your following any cyber security rules it’s 1 server for 1 purpose.

So you never mix database and application on the same machine.

Yeah there is a big thing with CrowdStrike at the moment, you need to ensure the exclusions are all set right for it and it is operating outside the SQL...

Is replication really the way you want to go on this.  Replication is a real pain in the ass when it goes wrong.

If what your after is more HA why...

CPU isn’t going to be your bottleneck soon it’s going to be Max database size and RAM.

1410MB which express will use for the cache is nothing these days and the...

No sql will go for 4 cores.

The lesser of so you can have 1 socket with 4 cores max for express.  No more.

If you can only run express due to the cost then you can only run what express can support, sorry but that is the license terms you agreed to when...

Declare @id numeric(17,2) = round(‘123.456’,2,1)

It depends.

You will come to hear that term for every question in SQL Server.

To fully understand the correct answer if temp tables or to persist it physically you will need...

Yes if your in full recovery which you must be for AOAG and not doing log backups then you have made the problem.

FULL/BULK recovery you MUST take log backups to...

You need to be doing very frequent log backups, or if your only doing it for read scale look at transactional replication instead where you can remain in simple recovery...

Alternative to SSIS is powershell and If you have them as CSV files using modules like DBATools and Import-DbaCsv, you can easily write loops in PowerShell to loop in a...

Look at writing it is SSIS instead of using the import wizard.

Using things like foreach loops etc.

As a starting point, if you use the wizard and at the end it...

The data type will need changing to something which allows 6 digits before the decimal place.

NUMERIC(10,5) max number is 99999.99999

So you would need a NUMERIC(10,4) for example which would allow...