It's that time again...TUESDAY!
https://www.mememaker.net/static/images/memes/4791280.jpg
I mean...NOVEMBER!
https://tinyurl.com/33hezsje
OK fine...SUMMIT!
https://img.memegenerator.net/images/10802365.jpg
I have very much missed in-person events and I am glad that Redgate (@Redgate) has managed to continue the @PASSDataSummit framework - virtual presentations...
2022-11-16
84 reads
I’m proud to be a part of the SQL Server communities globally. I do everything I can do to give back when I can. Too many times, I feel...
2022-12-02 (first published: 2022-11-15)
303 reads
We still don’t have an exact release date for SQL Server 2022 but at this stage we can have strong confidence that it will be with us before the...
2022-11-15
98 reads
Today’s coping tip is to sign up to try a new activity, course, or community. I somewhat did this early in the fall by choosing to go through the...
2022-11-15
30 reads
Hello Dear Reader! Last week I was fresh off of finishing the Run Dinsey 5K, 10K, & Food and Wine Half Marathon. My good friend Josh Luedeman (@JoshLuedeman |...
2022-11-14
96 reads
Many of us have learned how to research and get new information online. I certainly think the written word, whether from formal articles at places like SQL Server Central...
2022-11-14
15 reads
Today’s coping tip is to get outside and observe the changes in nature around you . Nature is changing in Colorado as winter approaches. It’s been a dry year,...
2022-11-14
32 reads
As I write this, it’s the weekeend before PASS Data Community Summit 2022 and depending upon when I finish, it’ll post either shortly before SQL Saturday Oregon, or in...
2022-11-12
52 reads
If you’re interested in getting a digital copy, my brand spanking new book is now available here. It’s in the intro, but let me tell you a little bit...
2022-11-11
265 reads
I’m traveling this morning. My second to last trip of the year, and another long one. Today through the 20th I’ll be in Portland and Seattle. First is Portland,...
2022-11-11
32 reads
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Comments posted to this topic are about the item Split Large Queries in Athena...
Comments posted to this topic are about the item 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