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

Try it with quotes around the table name.

1. Interesting question because it's really easy to get sloppy about these. I'm sure I do all the time. Here's Microsoft's tutorial on writing T-SQL Statements. Pretty sure there...

The host name is dependent on the connection string. If people leave this off, it's why you can't audit for it. You can use HOST_NAME to get this information...