Featured Blogger: Tim Mitchell
I met Tim about a year and a half ago at SQLSaturday Jacksonville and from the start we hit it...
2009-12-02
284 reads
Authors Needed for the SQL Server Standard (PASS) & Almost Engraved Invitations
SQL Server Standard editor Grant Fritchey needs more content! We’ve got about three done and three more in the pipeline,...
2009-12-02
957 reads
I think I’ll back up my laptop
Those were the first words out of my wife’s mouth when I told her my laptop had died. She walked...
2009-12-02
844 reads
What It Means To Be A Production DBA
Remember that scene from Office Space where the Bobs ask, "What would you say you do here?" I've been a...
2009-12-02
549 reads
Dr. DeWitt’s Key Note at the PASS Summit
If you missed this, here’s your chance to make it up. If you were there, and like me, you need...
2009-12-02
724 reads
SQL Standard Update
Andy Warren in the latest PASS Connector has posted an update on where we’re at with the SQL Server Standard....
2009-12-02
650 reads
Another Update on SQLSaturday
I’ve fallen behind a little on sharing SQLSaturday news, so I’ll try to catch up on the latest. First, we’re...
2009-12-02
496 reads
Under Repair
I’m glad I called Toshiba last night. When my laptop died on Sunday, and never came back Monday, I wasn’t...
2009-12-02
343 reads
Explain it to yourself
I found a nice post from a friend, Roy Ernest, on an effective way to learn. He notes that one...
2009-12-02
677 reads
Fundamentals of Storage Systems – Testing IO Systems
12/03/2009 - UPDATE! There were a couple of bugs in the SQLIOCommandGenerator new SQLIOTools.zip has been updated.
------------------------------------
I often tell people one...
2009-12-02
1,581 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