The PASS Session Selection Process, My Experience Part 2
In part one I talked about the abstracts. While important, abstracts are only one part of a complicated selection dance....
2010-07-09
478 reads
This week’s SQL Lunch was great !
Hey there SQL Lunchers. Your co-host Adam Jorgensen here. I wanted to let you know, for those of you whose...
2010-07-09
351 reads
Another Update on Goals
I was querying the SQLServerCentral database for something else today, and I decided to take a minute and double check...
2010-07-09
410 reads
SQL Server Agent – Proxy error
I was setting up some SQL Server agent jobs in a test environment. I needed one of our testers to...
2010-07-09
14,321 reads
Windows 7 Run As
One of the things that got us to switch OSes from W2K to WinXP when I was an administrator at...
2010-07-09
447 reads
PASS Update #36
We had our monthly Board of Directors call on July 8th and as is fairly common, the call went smooth....
2010-07-09
1,156 reads
PASS Summit 2010 Sessions Accepted
Excited to get the email yesterday that two of my sessions were accepted, Introduction to SQL Server Statistics and Building...
2010-07-09
414 reads
Free SSRS Training – SQL Lunch #23 (SSRS R2 – Shared Datasets & Report Parts)
Join SQL Server MVP, Patrick LeBlanc, next week on the SQL Lunch to learn about Share Datasets and Report Parts...
2010-07-09
1,562 reads
PASS Sessions Submitted
Hey guys, I’m preparing a few new article series for you but in the meantime I wanted to let you...
2010-07-09
322 reads
Last Book Chapter Submitted
Whew, I just got my last chapter submitted to the editorial team for our newest book. I still have to...
2010-07-09
348 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