A Focus on Novice DBAs: My Upcoming PASS Presentations
The PASS Community Summit 2008 is coming up fast (November 18-21, 2008), and if you are attending and you are...
2008-10-01
607 reads
Blog Posts
Managing My Todo List
I think everyone struggles with keeping track of things they need to do, and it's all too easy to get...
2008-10-01
483 reads
Reminder - MVP Andy Leonard Midlands PASS!
Speaker: SQL Server MVP Andy Leonard
Midlands PASS Chapter - October 2, 2008 Meeting
The Midlands PASS chapter will hold our normally scheduled...
2008-10-01
928 reads
When Will You Begin Implementing SQL Server 2008?
As I have been talking to DBAs around the country, I have noticed a trend that many, if not most,...
2008-10-01
380 reads
Notes from the Sep 24, 2008 Orlando .Net User Group Meeting
I don't seem to find the time often, but recently I was able to fit in another visit to the...
2008-09-30
1,381 reads
Returning Stuff to Amazon
I've used Amazon for years for the sheer convenience, and recently was the first time I ever needed to return...
2008-09-29
1,468 reads
SQL Saturday Orlando
Make sure you make it to the next SQL Saturday event that I will be speaking at October 25, 2008...
2008-09-29
1,307 reads
Technical Difficulties
Always something going wrong around here with the podcasts. Today I was editing a couple, or attempting to, and couldn't...
2008-09-29
1,446 reads
The Relational Manager and Managerial Relations - Why?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-09-29
1,368 reads
Data Quality, Part 1: The Discovery
I wrote a post a few months back about a healthcare data conversion project that I’ve been working on for...
2008-09-28
1,968 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