DBownership also by the same account ? ( check when primary on instance )

Read this: Author Jeff Moden - Article:  Tally OH! An Improved SQL 8K “CSV Splitter” Function, http://www.sqlservercentral.com/articles/Tally+Table/72993/

Example query:

SELECT ACC.ts_easeofworking
      ,...

• This reply was modified 3 years, 2 months ago by Johan Bijnens.

Read this:

Author Jeff Moden - Article:  Tally OH! An Improved SQL 8K “CSV Splitter” Function, http://www.sqlservercentral.com/articles/Tally+Table/72993/

Example query:

SELECT ACC.ts_easeofworking
      , GOM.ts_easeofworking
 ...

• This reply was modified 3 years, 2 months ago by Johan Bijnens.

If that is a business rule for your database, you should enforce it in the database. ( mainly to avoid manual mistakes )

ERD:

Drivers - id/name/...

Busses -  id/LicensePlate/Capacity/...

DriversBussesAllocation - Date/DriverID/BusID/... -->...

did you try adding an OUTER APPLY ( with e.g. DelimitedSplit8K or string_split ) to your queries to handle the multi valued column ?

Tell your client Microsoft advises this "Data Migration Assistant"

just remember when to unwind ....

By now, you know the solution.

Want to make it even better, do not use a SCALAR value function, but turn it into a (in-line)Table valued function !

In most cases, performance...

Instead of a WHILE loop you could try a numbers table or tally function approach

declare @string varchar(255) = 'EMA_20210526T211254_0000_MRNMM0000001240_PMS110460PAT000001287_PID15235307_OR_Dr';

select string_agg(v.chr, '') within group (order by...

Thank you for the feedback

Issue resolved for me. I have audits configured on my SQL Servers to write to a network share. The share had gone down, so when the server restarted, connections...

$Filename = $('Job_Runs_{0}.log' -f (get-date($OtherDate) -Format 'yyyy-MM-ddTHH-mm-ss'))

$Filename

• Can you relate to this post ? "sql-server-hung-state" pointing to a failing network share.

If you chose to use "managed backups" it will figure it out itself.

If you chose not to use managed backups ( as it's always been ), you decide what...

ref: "Troubleshoot query time-out errors"

ref: "How to detect query timeout errors with Extended Events"