How to Use Parameters Like a Pro and Boost Performance
Yesterday I presented my favorite session “How to Use Parameters Like a Pro and Boost Performance” in the DBA Fundamentals...
2016-03-01
316 reads
SWITCHing IDENTITY in the Pub
I was recently talking to a friend in our local pub about a problem he had with tables not using IDENTITY...
2016-03-01
672 reads
Find Char nullables to possibly go for not nullables
I often find columns in tables of the databases that are defined to allow NULLs but have non NULL values. That’s actually an experience of working with constraints and when I got to...
2016-03-01
7 reads
Find Char nullables to possibly go for not nullables
I often find columns in tables of the databases that are defined to allow NULLs but have non NULL values. That’s actually an experience of working with constraints and when I got to...
2016-03-01
9 reads
NULLs to Not NULLs
I have found many columns in many tables of many databases that are defined to allow NULLs but have non NULL...
2016-03-01
110 reads
Find Char nullables to possibly go for not nullables
I often find columns in tables of the databases that are defined to allow NULLs but have non NULL values. That’s actually an...
2016-03-01
118 reads
Comments on Proposed Changes to the NomCom Process
On Friday Thomas LaRock posted Changes to the NomCom Process on the PASS blog for comment prior to the Board...
2016-03-01
631 reads
Change Tracking for Data Warehouse Loads (Webinar)
For data warehouse professionals, data change detection is is a central part of what we do. Accurately detecting new, changed,...
2016-03-01
598 reads
Now exactly which proposal is this
Introduction
Oft times we are forced into situations where we clearly need to think outside of the box. A case at...
2016-03-10 (first published: 2016-03-01)
1,363 reads
Another Source of Knowledge
It started with a tweet from one the many members of the #sqlfamily who always has something meaningful to say,...
2016-03-07 (first published: 2016-03-01)
1,813 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