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"

#using Powershell
Get-Date -UFormat "%A %B/%d/%Y %T %Z"
$Time = Get-Date
$Time.ToUniversalTime()

#Using .Net
[System.TimeZoneInfo]::GetSystemTimeZones( )
[System.TimeZoneInfo]::ConvertTimeBySystemTimeZoneId( (Get-Date), 'Greenwich Standard Time')

If I understood well, a natural join is supposed to have no ON-clause as it uses matching column names

ref: https://www.geeksforgeeks.org/sql-natural-join/

Are all your sql server 2016 instances upgraded up to the latest sp/cu ?

Keep in mind, to be able to see the tables relationships, you need to be granted "View Definition" at database level

GRANT view definition TO [youraccount/group]

What do you mean with "second occurrence of a character" ?

I cannot see that in your "Left(Replace..." example.

Have you seen these questions/articles ?

• "removereplace-string-after-specific-character"
• "Split String Function"
• "

1. you are connected to a database !
2. You specify a table or view in a query
3. Via SSMS Object browser, you can rightclick and generate "select" or "edit" for...