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

Most people read more than one of the topics (or, like I do, look at which topics are new), so posting a question multiple times just leads to different answers...

Honestly, this is work I would put on to the front-end. There are ways to do translations. Otherwise, you're going to have to do pretty horrible stuff to your T-SQL...

Sounds great. Let me know when that gets implemented. I'm in.

If you are only storing the XML and not querying it or manipulating it in SQL Server, then I suggest you should use VARBINARY(MAX) rather than the...