The Saddest Thing I Ever Heard a Manager Say
I am currently going through the process of looking for a new opportunity for my career. I’m going through the...
2013-03-08 (first published: 2013-03-01)
6,051 reads
100th blog post
Unless you’ve entered “100th blog post” into your favourite search engine and clicked on pot luck (or whatever it is)...
2013-03-01
574 reads
Reblog: February 22 to February 28
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-01
934 reads
SQL Server Events in the UK – March 2013
Welcome to the first of what I plan to be a regular recurring theme. Right here I will list out...
2013-03-01
771 reads
Windows 8 – First Impressions on a Desktop
I bought a new (to me) desktop recently to replace my aging hardware. I’ve had a quad core machine, but...
2013-03-01
1,044 reads
Something for the Weekend – SQL Server Links 01/03/13
It’s SFTW Time, I hope you’ve had a great week!
Make sure you don’t miss this weekly round-up of SQL Server...
2013-03-01
1,079 reads
SQL BLOG: First Occurrence Of Character In a String
Scenario:
We need to find the first occurrence of character ie non numeric data in the string without using the built...
2013-03-01
2,795 reads
YYYYMM Math
I had a project recently where I had to do math on a number that represented a date, YYYYMM.
For example,...
2013-03-01
687 reads
Presentation Materials “A Function is a Function”
Here are the presentation materials for today’s Pragmatic Works Training on the T’s session A Functions Is A Function – Comparison of...
2013-02-28
1,282 reads
Insert multiple values sets into a table in one command
The INSERT command has two distinct ways to load data into a table.
INSERT INTO Table (field1, field2) VALUES ('string1','string2')And
INSERT INTO...
2013-02-28
3,451 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
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