We need to fix it because I suspect there will be a little bit of a brouhaha about the question & answer today.

Nope, sorry, still not working. I'm speaking about "Join the discussion and add your comment" link at the end of the answered page. This also happened last week with...

I can't find anything saying one way or the other in Microsoft's documentation or on the real source of information, Niko's blog. I'd say if it tests out, it works....

Nope, sorry, still not working. I'm speaking about "Join the discussion and add your comment" link at the end of the answered page. This also happened last week with...

Yep. Reinforce the correct answer.

Set a max memory that leaves a little bit for the operating system and walk away. SQL Server will use the memory you give it. And,...

To say the spid was never blocked doesn't mean it's not waiting on resources. It is. It's moving all the pages around. It can't move them while there are shared...

Check to see if you have a filter set. Try hitting refresh. Go and query the history table directly.

I didn't "fix...

Shocklingly enough, I got this one right.

Yeah, I know, I know. But I'm helping to keep an eye on the site with Steve on sabbatical. Part of this means I'm...

I'm currently doing the last bits & pieces of a DWH Upgrade / Replacement to 2017 and I already am screaming for SQL Server 2019 (MDS learns how to...

I know of a company that paid an astronomic sum to keep a warehouse distribution system supported on obsolete hardware and a long obsolete version of the software.

They had...

I agree with everything you said but, with all the really cool stuff that's been built into SQL Server in the last 8 years, couldn't you have cited a...

Happy to help. Good luck on the test.

I've never taken a single certification from Microsoft. Sorry.

The problem I have with the certs is that there is literally no way for them to know whether or not you...

Have you tried Azure Data Studio? I use that with containers all the time. It should work. You may have to use the IP address instead of just relying on...