this should be simple -

update MRF set Customer='x'+customer

@P1 is where between your app and sql it has parameterised a query

it looks a bit like "select * from sometable where somevalue=@p1" ,@p1='fred'

when you switch to a proc then...

American date format issues ? - your original code block had DATEFROMPARTS(2019,13,7)

usually when I see 13 in any date function then I fear it is trying to do the 7th...

No, you can't use wildcards in a DDL statement.  Either loop through the sequences and reset them one by one, or write a SELECT statement that generates all the...

I also have not seen this on any of my servers from 2008 through 2019

i do get a few issues with CPU in perfmon (related to perfmon counters not installed)...

Stopped gigging a while back, now it is only for my personal pleasure (read: when no one else is at home)

Same here, it's one of the disadvantages to the...

you could try changing the server setting to maxdop 1, but I really don't think that is the problem

I did not see anyone mention compressing the table - have you looked at those options to see if either row or page compression reduces the size of the...

do you need Nvarchar - could you go to varchar? it halfs the size of the field

https://cloudblogs.microsoft.com/sqlserver/2016/03/31/microsoft-sql-server-developer-edition-is-now-free/

acoustic jazz guitar and half decent pub standard upright piano... the guitar only comes out when the neighbours are on holiday and I need to relax

next update:

if i watch the CPU in taskmanager, after i openend processes in activity monitor, the vCPUs goes from 10 % to 30%. So it seems that the query...

I don't know about the backups, this concerns (only) my db-Admin. He restored some dbs, so that seems to work 😉

but when I copy a big chunk of data,...

wait, Wellen_reiter, is this a VMWARE server?

SOS_SCHEDULER_YIELD is typical of CPU pressure - particularly where a VM instance is sharing CPU with other instances (VMware tries to be clever about...

sql will start off using minimum memory - then as you run more queries then the mem usage will go up (data pages being put into buffer cache)

general rule of...