Restarting the share while the SQL Server has the database attached sounds like a terrible idea. You could very easily cause corruption. Generally it's a bad idea to attach a...

Considering you're using SQL Server 2016, have you considered using STRING_SPLIT? Provided you don't need to retain the ordinal position. Not to say thar Jeff's solution is bad (it's awesome)...

Perhaps the solution would, instead, be to use dynamic SQL, rather that a Catch all WHERE clause:

I know this particular user is a repeat offender for, but I feel they're getting worse. They've not even tried to solve the problem themselves, and they're not asking a...

That's not a question, that's a request. You've posted enough times to know the volunteers here aren't here to do your work for you (you're the one that's gets paid...

I wouldn't expect that value of give the correct result, your CHARINDEX would return the position of the first underscore after the 2nd character. As you're looking for the last...

Ahh, I see the confusion now. Upgrade means that you want to upgrade (for lack of better word) the version of SQL Server you have. So, if you have SQL...

Out of the box, no.

You could have a look at the default trace. Also, if you have your security setting to log both successful and unsuccessful logins,...

That query you've posted doesn't run (due to the random (A) after document_type = 'SI'. What is the (A) for? If you remove that,...

An alternative, without having to do a (possibly costly) double REVERSE:

SELECT a,
       CASE V.PI WHEN 0 THEN a
               ...

You said that you're switching the WordPress Steve, how will that work with the existing articles? Will the old links become dead, or will they redirect/be retained? There's a few...

No, you'll need to generate multiple reports and export each separately. Exporting a single report does not create multiple files, it creates a single file. A page break inserts a...