My understanding is similar to yours - SQL shouldn't let you run the same job twice at the exact same time.  I have tried doing this and it gives me...

Not SQL related, but you can do similar things with C# and other .NET languages if you use Visual Studio.

I like doing this when I make an application in C#...

I had a much nicer licensing audit that a lot of people I imagine.  I was terrified of being audited as I was SURE we were out of compliance but...

When is that error thrown?  Is it thrown during the database restore or at some other point?

Quick google of the error is being thrown by an AG during a sync...

Thanks Pietliden for putting the code in a consumable format without having to jump out to a 3rd party website.

SQL Espo, what have you tried already?  Posting what you have...

Multiply by 100 prior to doing your last convert.  your division (for example) is giving you 0.66666666666666... and you convert that to decimal(10,2), the number is now 0.67.  Then you...

Looking at your color chart and the way it is ordering it, to me it looks like you are ordering by region (North America, Europe, Pacific) first and by the...

I am not aware of any tools that do this automatically for you, but that doesn't mean there are not any.

Where I work, we don't actively monitor for things like...

I know we use SQL Aliases at my work and they can be a pain.  They are nice once they are set up and working, but what if a developer...

Quick check on your query, and if you look at the 3rd parameter to Substring (the LENGTH portion) you have this:

LEN(output_response_xml) - LEN(LEFT(output_response_xml, 
CHARINDEX ('>Thank you', output_response_xml)))...

To add to Steve's comment, there is more overhead than just the dataype overhead on a row.  On top of the overhead by VARCHAR and NVARCHAR, you also have the...

When I run your query with the date set to 21/05/20, the WEend Raised - Sund is the 24th and the Thursday one is the 21st.  Does this not match...

If you have the Russian language installed in Visual Studio with SSMS version 18.5, it lets you pick that from the settings.  I expect it is similar with SSMS 13. ...

Oh, it didn't come out wrong, I was just admitting that someone on here (ie me) with a lot of posts and been a DBA for nearly 10 years and...

To add to Jeff's reply, best practice is not always how you should set things up either.  Best practice is to use Windows Authentication and not use mixed mode.  I...