I'd use NOT EXISTS probably

SELECT e.EmployeeNo

FROM dbo.Employees AS e

WHERE NOT EXISTS(

SELECT sl.SalaryLevelID

FROM  dbo.SalaryLevel AS sl

WHERE sl.SalaryLevelID = e.SalaryLevelID);

There are other ways as well. An outer join & filter on NULL...

Thanks for taking on all the good comments everyone. I was away for a bit.

Phil suggested DevOps, which I heartily, vociferously, and vigorously agree with.

For some reason it was marked as Spam. I unmarked it.

I'll add PowerShell. Automate all the things.

Also, you said tuning,...

The Blocked Process Report is an event within SQL Server. That's what you're setting the threshold for. You can read about it here. And yes, some monitoring tools use...

Without seeing the query? Nope. Sorry. Sounds like you don't have the parameter in the WHERE clause maybe? I don't know because I can't see your code.

From your response Grant it sounds as though PASS and C&C actually figured out quite quickly what Covid was all about, especially with the Summit being in November, which...

PASS is a not-for profit organization, not a non-profit organization. About three years ago we investigated going full non-profit and it would actually have hurt our tax position, so the...

Hi,

A table contains approximately 6 billion rows. Now, if I ran a command like 'select count(*) from table;' to get the actual count. Will it slow down my system?...

Just to reinforce what @mr.briangale has already said, there is no magic number of indexes. If the indexes are being used and their maintenance is not causing you pain, whatever...

Regarding "the big party". I assume you all mean the Thursday party that for many years was a fixture of Summit?

That event was always hosted by Microsoft. It was never...

Just so people know, we have contracts with convention centers and hotels. These contracts get negotiated starting 3-5 years away from the event. This is in order to keep the...

It could be that there's a proc that you need to execute. Maybe a table that logs the login. It's hard to know. You could monitor using Extended Events to...

Sadly, at the moment, all I can say is the details are coming. I want them out yesterday. However, it looks like sometime next week.

In order to run a 330,000 member organization that does all the stuff we do, we have to have a management company. About 12 years ago we were with one...

Hey all!

In all likelihood, this will get me kicked from the board, however, I'd like to share something about my passion for this community and why PASS as an organization...