Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Working with results and manipulating them is always...
2021-12-29 (first published: 2021-12-20)
396 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-12-20
22 reads
(2021-Dec-20) Part of the continuous integration and delivery for Azure Data Factory involves pre-deployment and post-deployment steps. Their main role is to stop triggers before deployment and restart them afterward,...
2021-12-27 (first published: 2021-12-20)
3,493 reads
8. prosince jsme se opet sešli u obeda nad novinkami ze sveta dat. Je super, že se stále více úcastní i lidé mimo JC – jsme rádi, že se...
2021-12-27 (first published: 2021-12-19)
145 reads
Our holiday gift to the Microsoft Data Platform Continuity Virtual Group is to have a massive panel of industry-leading experts answer YOUR questions with no strings attached! Bring your...
2021-12-16
47 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-12-16
30 reads
Prior to 2017, the only way to get SQL Server running on a Mac was through a virtual machine running some version of Windows that supported some version of...
2021-12-15
74 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-12-15
24 reads
If you are an avid report designer or user, you may have wanted to see the percent difference between one row and the previous one. Sounds easy right? Well...
2021-12-24 (first published: 2021-12-15)
1,586 reads
There is a setting / feature in Managed Instance worth talking about, it is called SQL Trust Groups. What is this? At a basic level it’s a way to...
2021-12-15
125 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