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

Just...

HA!

Yep. Just one of the many...

• This reply was modified 6 years, 2 months ago by Grant Fritchey.

If you want to capture the commands without having to run sp_who2 (and oh boy, a ton of ways to get information out of the database better than that), just...