By Steve Bolton
…………I originally planned to post a long-delayed series titled Information Measurement with SQL Server next, in which I’d...
2016-06-20 (first published: 2016-06-13)
2,413 reads
I give a SQLSaturday session called "Introduction to Extended Events" and at a recent presentation I had a pair of...
2016-06-17 (first published: 2016-06-13)
6,494 reads
Usually on my Monday posts, I include a pretty bland cookie cutter header. Nothing to extravagant, just an introduction. It’s...
2016-06-13
774 reads
Post #6 of #entrylevel #iwanttohelp in support of Tim Ford’s (b|t) beginner’s initiative.
If you’re just getting started with SQL Server,...
2016-06-13
1,252 reads
One of the issues I’ve seen with Azure is that is changes rapidly. It’s cool in that new things get...
2016-06-13
531 reads
The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create...
2016-06-13
329 reads
A new ground-breaking feature in SQL Server 2016 allows report user context to be passed through shared data sources, enabling...
2016-06-16 (first published: 2016-06-13)
1,498 reads
Dear All,
It has been a while since I became less active on this blog. Reason for the same being that,...
2016-06-12
403 reads
The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not...
2016-06-11
17 reads
The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not...
2016-06-11
15 reads
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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