Trusts Are Transitive
If you’ve done networking in the MS world you know about the trust options between domains, and one of the...
2011-07-21
983 reads
Blog Posts
Announcing SQL Saturday #99
Seriously, what’s going on in Minnesota? Our government is shut down and… we are hosting a SQL Saturday on a...
2011-07-20
674 reads
BI on SQL Azure
Introduction
A newly emerged concept ‘cloud computing’ is a phenomenon which is quickly embedding into all sectors of IT industry. Data...
2011-07-20
530 reads
BI on SQL Azure
Introduction
A newly emerged concept ‘cloud computing’ is a phenomenon which is quickly embedding into all sectors of IT industry. Data Warehouse (DW) and Business Intelligence (BI) is...
2011-07-20
31 reads
Can You Endorse Me?
“Hey man, this is Ty*, what’s happening?” roared the familiar voice in my Bluetooth earpiece. It was a voice I...
2011-07-20
1,263 reads
Can You Endorse Me?
“Hey man, this is Ty*, what’s happening?” roared the familiar voice in my Bluetooth earpiece. It was a voice I...
2011-07-20
561 reads
DOS Batch File Date and Time
Written by David POstlethwaite
A non SQL blog for a change
Ever needed to create a batch file that wrote a time...
2011-07-20
1,384 reads
Got Married, Got Behind
No posts in a couple weeks, except the Re-Blogs. Guess the running around and getting married I did last week...
2011-07-20
470 reads
Knowing Someone Makes a Difference-Part 2
How long does it take you to get comfortable at a new job. How long to figure out who is...
2011-07-20
916 reads
PowerPivot - Measure Grid
There are a lot of fantastic new features in the latest CTP 3 release of PowerPivot, which you can download...
2011-07-20
2,516 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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