Ah... never mind... I found the reason for the disparity in the chat...

Looking forward to the meeting.

Thank you for the very kind words but I don't consider myself to be a master of anything.  I get real lucky on some things. 😀

I am a bit confused...

Good lord. 🙁

Could just be a lack of coffee but I have no idea how your combination of Product_ID and Qty would produce the results you posted.

NM.

NM.

Hi All,

Is specifying locking hints and set lock_timeout is a good thing or bad thing? I see a lot of this kind, in the app code?

Please share your thoughts...

Hi Jeff,

This is the sane sp_whoisactive which runs every 10 secs. if we are lucky enough sometimes , we are able capture those 3 sec SLA queries. Sorry for...

This seems like the very first event for a brand new group.  Is it a new Meetup Group?

You're welcome but I've done nothing on this thread except to like what a couple of others have stated...

You need to change the selection from seconds to minutes before you can type a "1" in there.

Also, if you already have sp_WhoIsActive running, why are you making another job...

Nicely done, Jonathan!

The optimizers suggesting for missing indexes are,...

The columns were permitted to be null for good business reasons.  I know that there are two (or possibly more) schools of thought about using null as a meaningful...

Based on the Compatibility Levels you've posted, there's a really good chance that this is because of a fairly major change they made to the "Cardinality Estimator" (CE for short)...