Sometimes, you have to fix it yourself
The Problem
SQL Server is a huge product with lots of moving parts. Bugs happen. Microsoft has a place to voice...
2010-02-18
2,019 reads
The Adversity Index
Found The Adversity Index while browsing and thought I’d share. It’s interesting to see the economic trends and I’ll let...
2010-02-18
506 reads
Free MSDN Azure Event in Orlando
Joe Healy is doing a four hour Azure training event on March 6, 2010 in Orlando, details and free registration...
2010-02-18
671 reads
Chicago Next Week
I’m in Chicago for a couple days next week, flying in on Sunday. Anyone in the area available for dinner...
2010-02-18
545 reads
Cumulative Update Package 8 for SQL Server 2005 Service Pack 3
Microsoft has released CU8 for SQL Server 2005 SP3, which you can get here. This is Build 4285. This CU...
2010-02-18
682 reads
May I help you?
With the Vancouver games underway, I have been reflecting on the 2002 Winter Olympic Games. Those were the greatest winter...
2010-02-18
832 reads
SQLSaturday#39 in NYC!
If you can't make #33 in NC, there's always #39 in NY -
SQLSaturday#39 in NYC!
It's shaping up to be another...
2010-02-17
648 reads
Mirroring a Large Number of Databases in a Single SQL Server Instance
Microsoft SQLCAT team members Sanjay Mishra and Prem Mehra have published a new Technical Note called Mirroring a Large Number...
2010-02-17
984 reads
Do I have to snatch the pebble?
Attending the Microsoft Certified Master (MCM) program in March
This is the most excited I've been since I heard that Alice...
2010-02-17
818 reads
Join the PASS Summit 2010 Program Committee
Just in case you didn’t see it, we’re looking for volunteers for the 2010 program committee – the team that evaluates...
2010-02-17
760 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