Beyonders
It has been a looooong time since I wrote a little book review. It’s nice to take time out with...
2011-09-16
559 reads
Ways to save money on Microsoft Software
If you are a developer and are on your own, or working for a company that does not have an...
2011-09-16
961 reads
Conflict Resolution
More than once I’ve run into situations where I’m working with two people/groups that don’t get along. Especially as a...
2011-09-16
624 reads
St. Louis SQL Server Users Group Feedback
You know I share what feedback I get from conferences. I don’t usually get feedback from users groups (well, I...
2011-09-16
865 reads
Dreaming
It’s easy to get so busy with life you forget to dream, at least for me. Most of us have...
2011-09-16
713 reads
Come and get your Data Education!
We all have been to various training courses throughout our professional career. Many follow a similar standard curriculum or course...
2011-09-16
926 reads
Import Data from AS400 to SQL Server
The process to import data from AS400 uses a SQL Server Linked server. The Linked Server points to an ODBC...
2011-09-16
17,176 reads
Probe Residual on Hash Match
I have to say, I only recently noticed this on a tool tip:
and this in the property sheet:
The bad news...
2011-09-15
1,695 reads
PowerShell for the Easily Frustrated N00b, or, “A Simple and Useful Command”
The stupid, stupid Windows search (Start Menu > Search) doesn’t work on one of my computers (running WinXP Pro). Yes, I made...
2011-09-15
488 reads
Analytic Functions – FIRST_VALUE / LAST_VALUE
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.
Analytic Functions in SQL...
2011-09-15
4,048 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