Klaus Aschenbrenner

Klaus Aschenbrenner provides independent SQL Server Consulting Services across Europe and the US. Klaus works with the
.NET Framework and especially with the SQL Server 2005/2008 from the very beginnings. In the years 2004 - 2005 Klaus
was entitled with the MVP award from Microsoft for his tremendous support in the .NET Community. Klaus has also
written the book Pro SQL Server 2008 Service Broker which was published by Apress in the Summer of 2008. Further
information about Klaus you can find on his homepage at http://www.SQLpassion.at. He also twitters at
http://twitter.com/Aschenbrenner.

All authors

All authors

Blogs

Goodbye, Microsoft

By

A few years ago I took a new job at Microsoft, working as a...

The SUM of Nothing: #SQLNewBlogger

By

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

I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...

Read the latest Blogs

Forums

Alamat BCA KCP ITC Roxi Mas Telp:08218520153

By layanan_Bca88

WhatsApp CS 628218520153 ITC ROXY MAS, Jl. Kh Hasyim Ashari No.125 Basement 13, RW.8,...

Alamat BCA KCP Sawah Besar Telp:08218520153

By R4nt4u

WhatsApp CS 628218520153 Jl. Sukarjo Wiryopranoto No.28 C, RT.1/RW.1, Kb. Klp., Kecamatan Gambir, Kota...

Alamat BCA KCP Pasar Tanah Abang Tlp:08218520153

By m4rt1n4

WhatsApp CS 628218520153 Jl. KH Fachrudin 36 Blok D/23, Kp. Bali, Kecamatan Tanah Abang,...

Visit the forum

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        Sally
I 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