If you could post an actual execution plan, it would make diagnosing the query much easier. Make it a plan that includes the aggregations because what you're seeing is changes...

Can't you just reverse the relationship then? The "child" sure sounds like it's the primary record more than the "parent".

For what it's worth, you could have a nullable...

The question you're attempting to answer consists of two data sets. One is the FirstName, etc, that comes from the straight forward part of the query joining Employee and Person....

Please, listen to what Lowell said. Don't shut off the server. I see that happen so often and it just makes this situation worse. Wait. It will clear eventually.

Happy to hear SQL Monitor is helping.

I agree on the community. SQL Server Central has helped me tons over the years.

By the way, if you do...

Blocking will lead to waits, but it's not necessarily going to appear in the top waits, depending on which resource is blocking on what. It can all get pretty much...

In addition to MAXDOP, it's a good idea to set the Cost Threshold for Parallelism to a higher value than the default of 5. Out of the box. You'll see...

It's only 10 at a time in the GUI. You can query the database directly to get more specific info if you want. If you highlight a query, you will,...

You absolutely cannot reference master from another database, so that won't work at all (currently, wait until the Instance as a Service is released, that could change). My immediate though...

Using SQL Monitor, you can sort the queries by duration, waits, several different ways.  If you use the top of the screen to highlight a particular time range, say the...