COPY_ONLY backs up everything that the regular backup does. It just doesn't put a marker down in the database that a backup has been done (possibly interfering with differential backups)....

I am a hop fanatic. IPAs are glorious and wonderful.

Thom has it nailed. Without information, we can't help.

One little point, depending on the type of query (and since we can't see it, who knows), putting everything into...

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