MAX DOP should also be changed as well as CTFP value as they likely on default (0 and 5 respectively)

DOP depends on how many CPU's you have - CTFP I...

SQL Server Agent job account needs access to the share/file - that is where it is failing now.

Or the Proxy account used to run SSIS packages if you defined one...

its documented even if not clear for some.

https://learn.microsoft.com/en-us/sql/t-sql/queries/from-transact-sql?view=sql-server-ver16

| derived_table [ [ AS ] table_alias ] [ ( column_alias [ ,...n ] ) ]

syscat is DB2

you need to get another admin to do it - or you setup a SQL agent job to delete it for you (but will need to kill all sessions with...

and using a sql agent proxy (can be per defined 1 per job) is in a way better than using the xp_cmdshell proxy (system wide).

on a multi-tenant server using the...

if you have to ask you likely don't need it - and I have to say that there is huge amount of info on the net so you asking here...

big transaction that required more space to be allocated - when it failed it did a rollback so space is there now - but wasn't when the transaction was running...

can you give the full command line - change servername and package to something else but meaningful - this so we can see exactly which parms /options you passing to...

One more question though. When we assign primary key to a column it creates clustered index by default on that column but I know that in future I will...

assuming you are using US formats you can do

select convert(decimal(10, 2), parse('$16,500.50' as money using 'en-US'))

for those who avoid twitter (like me) https://www.inverse.com/entertainment/babylon-5-reboot-cast-release-date-2023

I'm not sure how server specs would translate to different behavior in the query engine.  I did actually verify that the problem is version- specific.  And a calculation with...

even on the same version but with different server specs it can return different results - I would not consider it a bug but rather a consequence of using float...

I want more of B5... for work I would like those that don't understand the technology would include and listen to those that do in their discussions.