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.

Kubernetes!

There, now we all have to drink.

• This reply was modified 6 years, 11 months ago by Grant Fritchey. Reason: typo

I can't see a name associated with this, so I really can't judge whether the content is likely to be good or not. My opinion, it's a gamble, but it's...

So, I'm not a design purist. If I were, I'd argue that ONLY the natural keys should ever be used. However, there are very valid performance and design reasons why...

Let's start with the easy question first, output parameters. I've only used these in actual business work when I had the, very rare, circumstance that I was only returning a...

Thom has nailed the core answer. I just want to add one suggestion for tooling. Get a copy of Azure Data Studio and try it out as well since...

How about people that just implement missing index recommendations that create a nonclustered index that is a covering index and recreates the entire table?  Yes, I found one in...

BINGO!!  I would guess over 90% of the people who come to this site are not on a mobile device.  So why do we cater to such a...