SSWUG Free SSIS Expo – Today!
SSWUG Free Expo Event: Basic and Complex SSIS Features virtual conference is today! There’s a chance that you can probably...
2011-02-18
692 reads
StrateSQL
CHD Awareness Week
Do you know about congenital heard defects (CHD)? Did you know that February 7-14 is the week dedicated to making...
2011-02-14
478 reads
February PASSMN Meeting This Week
PASSMN meeting is this week on Tuesday. Without further ado…
Meeting Details
Here are the details on the meeting location and time:
Date:February...
2011-02-14
532 reads
Writing A Month Long Blog Series
You might wake up one day soon and think, “Hey, wouldn’t it be cool to write a month long blog...
2011-02-14
615 reads
Can You Dig It? – Find Estimated Cost
She can dig it!
D Sharon PruittIt’s the eighth post in the plan cache series. I hadn’t expect to take as...
2011-02-11
911 reads
Iowa PASS Presentation Materials
Driving to the User Group
This past Wednesday I took a drive down to the Iowa SQL Server Users Group meeting. ...
2011-02-11
485 reads
31 Days of SSIS Conclusion
31 Days of SSIS
Last month, I published the 31 Days of SSIS blog series. As a conclusion to that series,...
2011-02-10
785 reads
SQL Server MVP Daily Paper
A while back, I started a twitterlist of SQL Server MVPs. I wasn’t really sure why, but I just thought...
2011-02-10
548 reads
February PASSMN Meeting Announced
If you are looking for a change to get together with other SQL Sever professionals in February to talk about...
2011-02-07
722 reads
PowerShell: Download List of SQL Server MVPs
Turtle Shell?!
This weekend, I was working on something that I will blog about later this week. As part of that,...
2011-02-07
762 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
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