The Mystery of Missing Backup Files
Yoink – Backups Gone
Not only is this mystery of missing backup files worth discussing now, but has been a mystery worth...
2018-12-10
327 reads
Blog Posts
SQL Server on Docker
Started working on Docker and contains Install Docker on the system – please make a note that for windows 10 Home...
2018-12-08
318 reads
SQL Triggers – An Introduction
This article will give you the detailed knowledge about the SQL Triggers which can be very helpful in your work. It will gives information about triggers & its various...
2018-12-08
46 reads
SQL Triggers – An Introduction
This article will give you the detailed knowledge about the SQL Triggers which can be very helpful in your work....
2018-12-08
282 reads
Advent of Code 2018 – Day 6 (Chronal Coordinates)
Next, Advent of Code 2018 – Day 6 As I explained in a recent post, I’m participating in this year’s Advent of Code challenge, with the twist of doing...
2018-12-07
21 reads
Advent of Code 2018 – Day 6 (Chronal Coordinates)
Next, Advent of Code 2018 – Day 6
As I explained in a recent post, I’m participating in this year’s Advent of...
2018-12-07
259 reads
ASF 017 video invitation
What wasn’t really designed for people of guest’s stature? From who his every good decision does come from? New podcast...
2018-12-07
189 reads
Managing the Money for SQLOrlando
Part of the decision of setting up a non profit is committing to a bit more than minimal effort when...
2018-12-07 (first published: 2018-11-26)
1,732 reads
PASS, Meetup, and Sponsors
I’ve always been in favor of trying to use the PASS tools and web site as much as possible, but...
2018-12-07
765 reads
Things That Drive a DBA Crazy When Starting a New Job
In the past 5 months I have started two different jobs, so that leaves it up in the air as...
2018-12-07 (first published: 2018-11-26)
3,093 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