It's a feast or famine year. Not a good showing, though I really didn't have much on my bench that would have helped.

I'll be at Summit Mon/Tue only.

Thanks, edited the article and you are welcome.

Try this in a file, edit the SQLCMD to match what you need.

@@echo off
setlocal EnableDelayedExpansion
for %%x in (*.sql) do (
  set source=%%x
  echo sqlcmd -E...

• This reply was modified 6 years, 8 months ago by Steve Jones - SSC Editor.

Without persisted, this doesn't work. That was what the question tested, not if you can find a way to index a float column.

Good to hear. If you ever want to write up how this works for you, or how you do the imaging, we'd love to see an article.

If memory serves, it's a mix of commodity and cloud. However, they certainly share lots in the cloud, but use hardware to filter this down to reasonable levesl quickly, so...

I'm one of those who is older and this is a concern of mine. I've witnessed this close hand. My father was also in IT. His last position, in...

I think interviewing is...

Good comments, and interesting discussion. I'll give me thoughts on a couple things below in separate posts. I love that you embraced the chance to change minds, Philippe, that's great.

Sorry, @DinoRS,

We did have some migration issues with scripts, but they didn't quite make sense enough to find a pattern, so we've been fixing them as we can. Is that...

Glad to hear it. That's the main point of these...

Is this an ADS pipeline? What is your IF condition? How is the source data structured?

I know you can. Hoping you do, but no hurry. Feel free to teach it how you think best. If you want two articles (one on Stuff, one on common...

No, it was in response to some post, but I can't remember which one. I think they got some code, probably from you, and didn't quite understand how STUFF() works.

Thanks, glad you like it