T-SQL Tuesday #84 – Helping New Speakers
Ok everyone; here goes my first crack at replying to a T-SQL Tuesday. For those that don’t know what it...
2016-11-08
207 reads
A Good Deed After Game Night
When we set up Game Night, we decided to sell tickets to reduce our risk. However, we didn’t have a...
2016-11-08
570 reads
Growing Speakers for T-SQL Tuesday #84
It’s T-SQL Tuesday again, and for $#84, we have a non-technical topic. Hopefully this will then let us produce more...
2016-11-08
596 reads
The GUI Helps Build SQL Prompt Snippets
SQL Prompt is an amazing tool for writing T-SQL. It helps you to concentrate on your code, without having to...
2016-11-08
756 reads
PASS Summit Announcements: SQL DW free trial
Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. I’m writing a set...
2016-11-08
520 reads
Speaking? You? Go on. #tsql2sday #84
This is a blog post for this month’s T-SQL Tuesday post, hosted by Andy Yun (b|t). T-SQL Tuesday is a monthly...
2016-11-08
384 reads
PASS Board Update: Post-Summit 2016
Monday
I got in on Sunday and chose to have a small dinner with a couple of friends, quiet, preparing.
Monday was...
2016-11-08
431 reads
Notes from the 2016 SQLSaturday Roundtable Meeting
Each year PASS holds a meeting for SQLSaturday event leaders and key players on Tuesday morning. It’s a valuable meeting,...
2016-11-08
476 reads
T-SQL Tuesday #84: Growing New Speakers
This month's #tsql2sday is being hosted by Andy Yun (b|t) and is about helping new speakers.
I have only been speaking...
2016-11-08
436 reads
TSQL Tuesday #84: Zip to Speaker
Well, it’s that time of the month again. It’s T-SQL Tuesday yet again, and this time round it’s Andy Yun (b/t)...
2016-11-08
466 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