Running a Small User Group - Getting Quality Speakers
Midlands PASS is a small user group. We average about 15 people coming to meetings, which is good for Columbia,...
2009-12-28
1,195 reads
Scratch – A Programming Language for Kids
I ran across Scratch in a PC World article a while back. It’s a free download from MIT, and is...
2009-12-28
624 reads
Presenting a Live Meeting vs. a Real Meeting
I recently had the opportunity to present, Nuggets Found by Mining the Default Trace, for SQLLunch. This was my first...
2009-12-28
347 reads
Who Uses Rules?
Someone submitted an article recently that walked through how to find the rules in your database, which columns they were...
2009-12-28
766 reads
Little info about Resouce DB (SQL Server 2008-2005)
Little info about System Resource Database in (SQL Server 2008/2005)
The fifth system database in both versions (SQL Server 2008 - 2005)...
2009-12-28
1,374 reads
How To Get a Count of SQL Connections BY IP Address
These queries (which work on both SQL Server 2005 and 2008) are very handy if you want to know who...
2009-12-28
5,180 reads
I have pens!
We usually stuff stockings with little things for each other in the family. Sometimes it’s junk, or candy, but this...
2009-12-26
677 reads
Error Log:
Following steps happened when sql server starts… we can see that in error log::
1. Build of sql server and...
2009-12-25
680 reads
Merry Christmas 2009
Just a short Happy Holiday, Merry Christmas wish to everyone out there. Enjoying our White Christmas here in Denver.
2009-12-25
764 reads
Merry Xmas 2009
Hope you’re enjoying a break from the routine and spending quality time with family. Xmas for me is a time...
2009-12-24
685 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