Splitting CSV strings in SQL 2016
Up until SQL Server 2016, we had to write our own functions to split a CSV string into a table...
2016-09-15 (first published: 2016-09-08)
2,745 reads
Pluralsight courses available with MSDN Subscription
One of the benefits of having an MSDN Subscription is that you have free access to some Pluralsight courses.
To verify this,...
2016-09-08
578 reads
SQL Sentry Does It Again–Plan Explorer 3.0
Being in a shop that utilizes Plan Explorer it was awesome to hear of the news release from SQL Sentry...
2016-09-08
429 reads
Speaking at IT/Dev Connections 2016
I’m happy to announce that I’m speaking at this year’s IT/Dev Connections conference held at the ARIA Resort in Las Vegas...
2016-09-08
353 reads
SA Spoof
This is nothing new but it’s still a fun idea.
The problem:
The vendor app we just purchased (and are told we...
2016-09-08
492 reads
Are you going to SQL Saturday Denmark? #SQLSaturdayDenmark
Are you going to SQL Saturday Denmark, which is running on Saturday 17th September? If you are David Postlethwaite or @postledm...
2016-09-08
435 reads
Sql Server Special Table Types
Special
Table Types
Objective of this post is to provide a list of special
tables available in Sql Server and brief description of...
2016-09-08
208 reads
Reminder: Webinar today
This is a reminder that I’ll be giving a webinar today on managing SQL Server Agents jobs in a SQL...
2016-09-08
396 reads
Sql Server - Finding Duplicate Indexes
If you are reading this article, I assume
that you have basic knowledge of Index, its types and usage.
Over the...
2016-09-08
203 reads
Recap of My 24HOP Session – From XML to JSON
Yesterday I presented my session From XML to JSON as part of the 24 Hours of PASS online event. There...
2016-09-08
209 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Split Large Queries in Athena with a Simple Modulo Trick
Comments posted to this topic are about the item Split Large Queries in Athena...
Finding Trailing Spaces
Comments posted to this topic are about the item Finding Trailing Spaces
Question of the Day
Finding Trailing Spaces
I have some data in a SQL Server 2025 database. It looks like this for the dbo.Customer table:
CustomerID CustomerName PreferredName 1 Steve Steve 2 Andy Andy 3 Brian Brian 4 Allan Allan 5 Devin Devin 6 Steve Steve 7 Sally SallyI want to detect which names have a single trailing space. The CustomerName is a varchar() and the PreferredName is a CHAR(). Does this query detect the problem rows?
SELECT
CustomerID,
CustomerName,
PreferredName
FROM Customer
WHERE CustomerName <> RTRIM(CustomerName)
OR PreferredName <> RTRIM(PreferredName); See possible answers