Recently I was analyzing a stress test result for an AG configuration, and as usual I was reading to SQL error logs to see if there is anything out of...
2016-11-07
13 reads
Recently I was analyzing a stress test result for an AG configuration, and as usual I was reading to SQL error...
2016-11-07
1,616 reads
This requires an immediate caveat. You should absolutely be using sp_executesql over any type of non-parameterized execution of T-SQL. You...
2016-11-07
1,209 reads
I’ll have several more posts this week on specific activities at the Summit, but wanted to start with how the...
2016-11-07
378 reads
Back in September I received a call from my MVP lead that I wasn’t being renewed. Not a big surprise,...
2016-11-07
386 reads
Applies to: xSQL Schema
Compare v7.0.0 – 9.0.2
Before I develop a scenario where
xSQL Schema Compare snapshot comparison is necessary let’s explain what xSQL
Schema snapshots are. An xSQL Schema snapshot is...
2016-11-07
22 reads
Applies to: xSQL Schema Compare v7.0.0 – 9.0.2
Before I develop a scenario where xSQL Schema Compare snapshot comparison is necessary let’s...
2016-11-07
365 reads
I haven’t written much in a while, having had to put more time into both personal and professional obligations over...
2016-11-07
369 reads
Last week I shared my custom Query Store Dashboard that can be used to view additional performance information that isn’t...
2016-11-07
2,142 reads
By Steve Bolton
…………Information on set operations like complements, intersections and unions is plentiful in the literature on fuzzy sets, which...
2016-11-07
797 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