Paste the plan is probably better than this.

Well, if I'm looking at the right query plan, #10?, it looks radically different. 1 row out 4 estimated? The last one was...

But why a sort. There's no ORDER BY and the join is a Nested Loops, so order is not required. That's an odd choice in the plan.

I don't necessarily consider myself a complete [expert] in SQL Server, but that feeling isn't based on any inferiority complex, because I actually don't believe most self professed experts...

It seems to me that you could have all the certificates under the sun and be next to useless or none at all and be really good. The only...

Good question, Grant. I've seen some well known companies do very rigorous testing and interviewing of the candidates. I'd get the feeling that they really had a good idea...

Try the test again, but use a SEQUENCE. You should see the same results. It's because of the processing needed for maintaining an identity value versus the calculation of the...

100% agreement on Extended Events, but don't try to write directly to a...

Why not use Extended Events to capture logins? You see logins start and finish. You can see them fail. All through extended events. This will be faster than a trigger...

NOLOCK everywhere <sigh>

This stuff is going to prevent good index & statistics use:

           AND c.PatientID = ISNULL(@PatientID,...

Not that shocking. To use an IDENTITY column, you need to write data somewhere, whereas the ROW_NUMBER() is just a calculation.

Without the complete data set, I'm guessing a little, but try something like this:

SELECT i.item_code,
       i.cost_standard,
     ...

"Negativity, tearing down, just generally poor behavior doesn't do anyone any good. Best to always be, as much as possible, uplifting. It does get hard sometimes though, just saying."

I...

Yep. You'll have to do that. Or, you could use Extended Events. The connection_accept event has the IP address. Also, the existing_connection event captures all the available information for the...

Thanks for the feedback guys.

Jeff, you'd never hire me. And yes, I love that video. Thanks for burning 7  minutes of my morning forcing me to re-watch it. HA!

David, yeah,...

It's not a problem in any way. Just trying to be helpful. You'll get a better, more consistent response this way.