A Little About String Splitting In SQL Server

Become a member! / @erikdarlingdata If you like what you see here, you'll love my advanced performance tuning training:
training.erikd...
Get $150 off PASS Data Summit 202 with discount code DARLINGE24 Click here for 50% off a health check: training.erikd...

[@alexandermayerkirstein]

Using your own fingers held up while counting out whatever number your sharing takes me back to when learning was fun, when milk and cookies were served in class and when we didn’t have to count past ten. Really seats the knowledge your sharing into my brain right along side my memories of ms. West my almost forgotten preschool teacher. Unique, like you. Btw, are your picnicking rates on par with the competition and do the rates fluctuate with weather conditions? Oh never mind I’ll never get my employer to add fun in the sun with Eric Darling to our budget. Maybe if you pitched it as DBAs Gone Wild? A man can dream, goshdarnit!

[@ErikDarlingData]

I think someone tried that and called it SQL Cruise. I was never invited, but I get terribly sea sick anyway. A+ comment.

[@alexeybozrikov2413]

👍 now that's one clever thought!

[@omkardande1]

This knowledge could have saved me from so much pain in 2013-2014.

[@ErikDarlingData]

What knowledge would save you from pain now? 😃

[@omkardande1]

@@ErikDarlingData finding which operator is the most expensive in large query plan. I still find it difficult to pin point a operator that's taking most the time.

[@ErikDarlingData]

@@omkardande1 I talk about that quite a bit in my videos. Often the only way to truly know what the problem is, is to get the actual execution plan and pay close attention to operator times. Operator costs are basically useless.

[@omkardande1]

@@ErikDarlingData i appreciate you sharing your knowledge.

[@cartercordingley6062]

What about an if it already in a table
Select t.colname,s.columnname
From table1 t
outer apply spilt_string(t.listofId,',') s

[@ErikDarlingData]

I’m not exactly sure what your question is here, sorry.

[@zammea]

Hi, at work we are rewriting that just now. There is a problem I'm facing and I would appreciate the help. Most of the string_split is used in a function. Some of the functions are inline and receive a input variable of coma concatenated ids then it does a look up to check if the id have a to be treated as different id.(Yeah, I'm bad at explaining).
What I want to say is when a that kind of select is done in a function it make situation much worse and yes, I ask myself is rewriting everything worth it, and is it there a way to "Save" the function? I did try using User Defined Types (table) but it acted kind of the same.

[@ErikDarlingData]

That’s a bit much for me to make heads or tails of as a wall of words problem. You may have better luck posting with more detail on dba.stackexchange.com

[@douglascoats7081]

those indexes are built to spit on that thang, you get me?

[@ErikDarlingData]

SPLIT that STRANG ahem. We are a family friendly channel.

[@douglascoats7081]

@@ErikDarlingData family friendly with fun little easter eggs lol

[@igo_s5717]

Again great knowledge sharing. Truly appreciate it. This time also query explained which makes it even better.
New shirt also rocks.

[@ErikDarlingData]

HAHAHA, thank you!

[@douglascoats7081]

coupon? 😘🥰😍

[@ErikDarlingData]

It’s in there!

[@mirinda101]

Nice index naming there :)

[@BrandonChampion]

ptooey

[@ErikDarlingData]

🦅🦅

[@xthebumpx]

What do you use for drawing rectangles on screen?

[@ErikDarlingData]

Zoomit: learn.microsoft.com/en-us/sysinternals/downloads/zoomit