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

Ah... totally got it.  Thank you for the feedback.

Understood on the 3 second SLA but that doesn't seem to be the predominant issue.  The 1 or 2 day sleeping spids...

Thank you, I think the other factor is that there are more than 100 tables that have dependency on this table, so the delete might be looking into all...

I can't help on AOAG because I've never had to use it.  Once someone helps you figure that out, I can give you a very strong hint on how to...

Almost without exception,...

Jeff, when done right, natively compiled stored procedure achieve incredible performance gains. They are compiled software (DLLs), much like C++ code. The problem is that there are many limitations...