A Little About String Splitting In SQL Server

Published: 26 June 2024
on channel: Erik Darling (Erik Darling Data)

1,169

In this video, I dive into the appropriate use of string split in SQL Server queries and share a discount code for Pass Data Community Summit 2024, which is coming up on November 4th through 8th in Seattle. If you're considering attending but need some financial flexibility, or if your employer needs to save $150, using the code Darlingy24 will get you $150 off a three-day conference ticket. I also highlight why it's crucial not to split strings directly within queries and demonstrate how doing so can lead to poor performance. By splitting strings into a temporary table first, you can significantly improve query efficiency and accuracy. Whether you're passing comma-separated lists or other delimited data in your SQL Server queries, this advice will help you write smarter, more effective code. So, if you want to save some cash and enjoy the benefits of Pass Data Community Summit, make sure to follow my channel for regular updates and use the discount code today!

CHAPTERS

00:00:00 - Introduction
00:01:09 - Discount Code Offer
00:02:34 - Demo Setup
00:04:04 - String Variable Explanation
00:05:34 - Query Performance Issue
00:06:10 - Bad Way of Doing Things
00:07:42 - Temp Table Solution
00:09:27 - Query Plan Analysis
00:10:54 - Query Execution Time
00:13:34 - Improved Query Performance
00:16:32 - Appropriate Use of String Split

━━━━━━━━━━━━━━━━━━━━━━━━━━
📚 TRAINING & COURSES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Get AI-Ready With Erik
https://training.erikdarling.com/get-...

SQL Server Performance Engineering Course
https://training.erikdarling.com/sql-...

Learn T-SQL with Erik
https://training.erikdarling.com/lear...

Everything Bundle:
https://training.erikdarling.com/?cou...

━━━━━━━━━━━━━━━━━━━━━━━━━━
🛠️ CONSULTING & SERVICES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Need SQL Server performance help?
https://training.erikdarling.com/sqlc...

━━━━━━━━━━━━━━━━━━━━━━━━━━
💬 CONNECT
━━━━━━━━━━━━━━━━━━━━━━━━━━
Ask questions at Office Hours
https://erikdarling.com/officehours/

Become a channel member
/ @erikdarlingdata
━━━━━━━━━━━━━━━━━━━━━━━━━━

On this page of the site you can watch the video online A Little About String Splitting In SQL Server with a duration of hours minute second in good quality, which was uploaded by the user Erik Darling (Erik Darling Data) 26 June 2024, share the link with friends and acquaintances, this video has already been watched 1,169 times on youtube and it was liked by 83 viewers. Enjoy your viewing!

234