Board Election for the North Texas SQL Server User Group
The new year is less than 24 hours old and I’ve already been blessed with two different honors. I shared...
2010-01-01
555 reads
Three in a Row – MVP Renewed
I woke up this morning, late, after a great New Year’s Eve with friends. Too tired to get out of...
2010-01-01
350 reads
Three in a Row – MVP Renewed
I woke up this morning, late, after a great New Year’s Eve with friends. Too tired to get out of...
2010-01-01
333 reads
I’m a Microsoft MVP!
I received a notification e-mail earlier this morning that I’ve been selected as a Microsoft SQL Server MVP for 2010! ...
2010-01-01
908 reads
Re-Awarded MVP Status for 2010
I have been re-awarded MVP status for SQL Server for 2010. It's a humbling honor, and I will strive again...
2010-01-01
937 reads
2009 Goals in Review
Late last year, I blogged about some goals I had set for myself to accomplish during 2009. No goal-setting session...
2010-01-01
1,118 reads
Saying Goodbye To 2009
I'll close out 2009 with an update on the goals I set at the beginning of this year and things...
2009-12-31
1,402 reads
My Biggest Weakness
I took some time off in December and I'm finally getting around to catching up on RSS feeds. Turns out...
2009-12-31
1,522 reads
Stored Procedures to Store and Get Database Users with All Permissions
Introduction
Traditionally when doing a restore, moving a database, etc. a DBA would simply go into Management Studio and use the...
2009-12-31
1,803 reads
[OT] Happy New Year
Well, it's been an interesting year. I got to teach four different brand new SQL Server courses, and teach classes...
2009-12-31
1,349 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
ALAMAT BCA KCU SURYOPRANOTO Tlp:08218520154
WhatsApp CS 628218520154 Jl. Suryopranoto No.40, RT.12/RW.7, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat,...
Alamat BCA KCP Sentral Cikini Telp:08218520154
WhatsApp CS 628218520154 Jl. Pegangsaan Timur No.1, Cikini, Kec. Menteng, Kota Jakarta Pusat, Daerah...
Alamat BCA KCP Pintu Air Telp:08218520154
WhatsApp CS 628218520154 Jl. Pintu Air Raya No.36 Q, RT.6/RW.1, Ps. Baru, Kecamatan Sawah...
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