A Letter To A Younger Yates
Hello much younger Yates. Hope you’ve been doing well. Why don’t you pull up a chair and stay for a...
2017-01-31
692 reads
Join webinar on SQL Server 2016 Always on
Click [HERE} to Join webinar.
SQL Server 2016 - AlwaysOn
An availability group supports a failover environment for a discrete set of user databases, known...
2017-01-31
554 reads
SQL Server 2008 RTM - Maintenance Plans need Integration Services installed
The tail end of last week was a bit of a throwback week for me. For reasons that I’ll not...
2017-01-31
913 reads
Speaking at Techorama 2017
I’m delighted to announce that I’m selected as a speaker for the Techorama event.
Techorama is a developer congress focusing (but...
2017-01-31
676 reads
Another 5 Power BI Tips
If you’ve been at least paying attention to my blog a little bit, you’ve probably noticed I occasionally blog about...
2017-01-31
1,158 reads
Parse Dynamics AX Context Info
In this article I will only be discussing the AX product and an easy tweak to make troubleshooting that product much easier from the perspective of the database administrator....
2017-01-30
25 reads
Parse Dynamics AX Context Info
Dynamics AX and SQL Server
More and more I am seeing clients requiring assistance with the Microsoft Dynamics Suite. Each of...
2017-01-30
2,135 reads
A New Year, A New Company and A New DenverSQL Chapter
2016 was a great year, both personally and professionally. Personally, our family is well and the kids are growing into...
2017-01-30
645 reads
#ReadyRoll at #SQLintheCity
When Redgate purchased ReadyRoll a few years ago, I wasn’t sure this was a great idea. After all, SQL Source...
2017-01-30
786 reads
Warning: Not a valid checkpoint file name
One of the other DBAs I work with noticed a warning message that was flooding the log files on one...
2017-01-30
1,891 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