no...

is ti sql 2019? we've seen a few issues with functions not behaving as expected - not honouring order by... is it possible that this is another sql 2019 bug?

if...

Good DBA you should see the number of times an app on some estates breaks on the 13th of the month - usually not figured out until valentines day...

ALL nonclustered? so it's a heap? - I have no idea how SQL will handle 55 million rows with regard to page splits at that point

I'm afraid we have all...

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