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 7 years 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...

And this thread just keeps on keeping on... This is a pure rant, so read at your own risk. I have been involved in the interview process for a...

One of my experiences, though, is it does seem the SQL Server community is much friendlier than the Oracle community.  Not to say there aren't helpful people out there,...

It's been a while, but I'm pretty sure that NOLOCK was only a table hint in 2005, not a query hint. That means you can't use it in plan guide...