The Value of an Artist
A short while ago someone complained that some of the headlines on SSC were deceiving in terms of what they...
2010-06-15
663 reads
Teaching ICT 4462 – Transact SQL Programming at Denver University, University College
I will be teaching a special five week version of ICT 4462 – Transact SQL Programming at Denver University, University College...
2010-06-15
632 reads
DBA Hell
On the first day of DBA hell, the server gave to me
A database with damaged system tables and no good...
2010-06-15
969 reads
Virtualizing Servers in Production
The company where I work has been using virtualization in development, QA, testing, etc., for many years now. We have...
2010-06-15
880 reads
Daily SQL Server 2008 New Features – Day 23
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-15
424 reads
SQL Server XML Schemas
Ever been curious about the schema of , say an SSRS rdl file ? How about the execution plan ?
Not only should...
2010-06-15
502 reads
Networking – A Year Later
I was excited to attend the networking session last year at the PASS Summit. Andy Warren and I had talked...
2010-06-15
665 reads
oPASS Meeting Tonight June 15, 2010 – Featuring Kendal Van Dyke
We’re meeting from 6-8 pm as usual, with Kendal Van Dyke presenting Paging Dr Availability, You’re Wanted In the Recovery...
2010-06-15
314 reads
Report Render Duration
Every once in a while I come across a scenario where I really want to know how long it took...
2010-06-15
563 reads
Maps in Reports!
I’ve been playing with SQL Server 2008 R2 for quite a while in the CTP’s and what not. But, I hadn’t made...
2010-06-14
1,235 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...
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
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