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.

Memory use within Azure is pretty much the same as within SQL Server. Over time, it's going to go to near 100% allocation, always. It includes the cache, so your...

Ah, the joys of old knowledge repeated forever, despite things changing.

Read the docs. System functions can start with @@ and they used to be called global variables. They're not...

Would you believe... both.

If you look at an execution plan that is in row mode, not batch mode, it's actually doing all the commands it does, one row at a...