Project Phoenix expands to Australia and New Zealand
A couple of months ago, many Microsoft MVPs received Visual Studio 2010 Ultimate MSDN subscriptions (retail value: ~$12,000) to distribute...
2010-09-13
629 reads
SQLSaturday #52 - Colorado Details
What is SQL Saturday?
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server....
2010-09-12
513 reads
2010-09-10
457 reads
PASS SQLRally Pre-Conference Seminars – The Application Process
Today we’re announcing the call for speakers for pre-conference seminars at the first SQLRally being held in Orlando in May...
2010-09-10
752 reads
PASS Summit Logo Design Contest
It appears our success with the SQLRally Logo Design Contest has struck a chord with PASS HQ. This morning Rick...
2010-09-10
819 reads
Mastering PowerShell – Free EBook
Someone who I follow on twitter posted a tweet recently with a link to a free eBook on PowerShell. I...
2010-09-10
2,591 reads
Is Your Database “Web-Scale”?
It’s not safe for work (NSFW), so be sure that you’ve implemented a cone of silence as appropriate for your...
2010-09-10
612 reads
Goal Update - Misc accomplishments
I have been trying to better track my goals this year, and find myself failing at some, exceeding at others....
2010-09-10
426 reads
McClintock!
I was channel flipping after dinner when I saw this and had to stop to watch a few minutes of...
2010-09-10
311 reads
24 HOPASS Bonus Sessions ..
Just for info that the incoming 24 Hours of PASS now has bonus sessions ...you can check for the details...
2010-09-10
728 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