With reports hitting the transactional databases, we were encountering performance issues. We needed to choose a path forward that would lighten the load on the prod database servers and...
2023-11-27 (first published: 2023-11-16)
633 reads
Morning from the PASS Data Summit! I will be live blogging the event again today, so check back for announcements and releases throughout the keynote. Today, we will dive...
2023-11-16
78 reads
Cosmos DB has become my latest focus and I hope to start sharing more about ways you can use it. Cosmos DB doesn’t provide the same granularity of query...
2023-11-29 (first published: 2023-11-15)
257 reads
On November 29, 2023, at 11 AM Eastern Standard Time, I'm presenting a webinar on how to harden SQL Server.
2023-11-15
196 reads
Morning from the PASS Data Summit! I will be live blogging the event today, so check back for announcements and releases throughout the keynote. Today, we have Shireesh Thota,...
2023-11-15
116 reads
I suspect many people assume this is the case, but a customer recently asked if SQL Compare handles indexes. It does, and this post shows the basics of index...
2023-11-15
186 reads
When I review customers database environments, I always check to see what the recovery model is for their databases and review that with the customer. I often times have...
2023-11-15
29 reads
I am the host for T-SQL Tuesday this month, and I hope that a lot of people like the topic. This idea actually came to me earlier this year...
2023-11-14
66 reads
For those looking to be first in line when my book is available for a printed copy, I’m very excited to let you know that it is now available...
2023-11-14
43 reads
In a previous blog post, I showed you how to use PowerShell to retrieve the details of the certificate being used for encryption-in-transit, aka TLS encryption. I have received...
2023-11-22 (first published: 2023-11-14)
1,711 reads
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
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