Absolutely tell your manager, boss, team lead whatever. You don't need to tell the whole company. However, you don't want to look like you're attempting to hide it. Honesty and...

There was a time when my primary concern on something like this would be simple worries about whether or not the junior (or senior, or mid-range) developer should be on...

Same answer as on your other question. Parameterize the queries. Don't execute strings.

Switch all your dynamic T-SQL to use sp_executesql. As you can see in the documentation, you can write that such that it uses parameter values, not just constructed strings....

Sounds like you're progressing well. I can't see the execution plan to make any suggestions. Also, an execution plan isn't a picture. It's all the data in the properties behind...

Absolutely Eddie's answer, or, use parameterized queries and then you simply pass the normal string, Women's, to the parameter with no additional work required.

Hey Barry,

Great to hear from you again.

Yeah, we sold everything to Oracle. Like it?

Love to see the execution plan for this. Especially if it's estimating that many rows but choosing to do nested loops instead of hash or merge. It's estimating that many...

Applying for jobs the trick is to get past the HR department. You do this one of two ways. First, you meet all their requirements, which may include certifications. Second,...

I'll be the contrarian here.

What I heard is one organization where technology is a necessary evil. While it's quite comfortable, you're not really going to grow and expand much in...

Interesting. I just validated that this will fail on SQL Server 2019 as well as SQL Server 2017. The logic of the OUTER APPLY must be somehow invalid. I'm not...

Without the full structure, the execution plan and the statistics, it's hard to say. Is visitduration a calculated column or something like that? It might explain it (maybe). If you...

Anyone feel like they know a darned thing about merge replication? I've been asked to help with this, but I'm way out of date on my knowledge. Go here.

My replication knowledge is OOOOLLLLLDDDD, like dinosaurs, so take anything else I say with a giant grain of salt.

The errors look like permissions issues. The error itself is saying that...

Personally, I wouldn't do this through T-SQL. I'd use Powershell. Here's an example.