Hi Everyone, this is John Sterrett. I am a SQL Server Consultant in Austin, TX. Last year I blogged about a feature called Persist Sample Percent. It had a...
2021-09-22 (first published: 2021-09-14)
1,103 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-09-14
40 reads
Quick query today. I needed a list of database sizes so came up with this: Nothing exciting, but I figure ... Continue reading
2021-09-22 (first published: 2021-09-14)
448 reads
First step login into the Azure portal and find SQL Managed Instance and click create. Yes you can find these tutorials all online but this is my thinking and...
2021-09-14
155 reads
My updated course “Managing Kubernetes Controllers and Deployments” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to dive right...
2021-09-14
27 reads
Data Masker for SQL Server is a great tool ensuring the data you use in non-production environments is compliant with any regulations by obfuscating and changing sensitive data. This...
2021-09-20 (first published: 2021-09-13)
210 reads
While I have not yet signed the contract, I have submitted an outline and proposal for a new version of my book on query performance tuning. Most of the...
2021-09-13
10 reads
While I have not yet signed the contract, I have submitted an outline and proposal for a new version of my book on query performance tuning. Most of the...
2021-09-13
48 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-09-13
24 reads
As part of its ‘All Cloud’ push that began to take shape in 2019, Connect for Health Colorado (C4) selected Matillion ETL to be its cloud ETL/ELT tool. At...
2021-09-12
40 reads
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Comments posted to this topic are about the item Split Large Queries in Athena...
Comments posted to this topic are about the item 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