My Experience with a Virtual Assistant using TimeSvr
Predicting the future with bold certainty is not for the faint of heart. It’s a hard job. A few get...
2010-03-12
974 reads
Great Turnout for The Montreal XV's First Practice - Rugby XV de Montréal Première pratique
The Montreal XV Rugby Club (rejuvinating the Rugby Football Club name from the 1920s) first practice was the other night at Collège Marie...
2010-03-12
807 reads
Working for/with High Caliber Folks
Within a couple of days of each other, both Andy Leonard (@AndyLeonard) and Paul Randal (@PaulRandal) tweeted about possible job opportunities which would...
2010-03-12
1,863 reads
SPB Applications for Windows Mobile
<<placeholder>>
…for product review
Weblog by Paul Turley and SQL Server BI Blog.
2010-03-12
420 reads
No Green Compromises
I saw this blog about an Accenture survey of potential car buyers. It mentions that people likely won’t buy a...
2010-03-12
930 reads
Another Presentation Down
This evening I had the opportunity to once again give a presentation at our local SQL Uses Group (SSSOLV). I...
2010-03-12
633 reads
Operation: Dinner Different
My wife and I try to have dinner out every other week or so, but we tend to fall into...
2010-03-12
793 reads
Don’t Be a Shock Jock
One of the dangers of being an “Internet Journalist” or even just a blogger, is that you might compromise who...
2010-03-12
1,013 reads
Orlando Code Camp – March 27, 2010
I’ll be attending and speaking at the Orlando Code Camp on March 27, 2010 at Seminole State College along with...
2010-03-12
556 reads
SharePoint 2010 and Various Versions of SQL Server
Microsoft has recently announced that SharePoint 2010 and Office 2010 will RTM in April 2010, and will be officially launched...
2010-03-11
5,841 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