PASS Update #56-SQLRally 2012 Site Selection
Note: This is a good, bad, and ugly post. We took some chances, got some things right, got more than...
2011-06-13
995 reads
What’s a Disaster?
In working on my Preparation for Disaster presentation and doing research, one of the questions that came up early for...
2011-06-13
1,496 reads
Time for a Little PD
No, PD doesn’t stand for PowerShell Development. It stands for Professional Development. Sharks either swim or die (and yes, I...
2011-06-13
740 reads
2011-06-13
Afterthoughts: SharePoint Saturday Tampa 2011
This past Saturday June 11th, 2011 I had the opportunity to co-present at SharePoint Saturday Tampa thanks to a special invitation...
2011-06-13
1,077 reads
Non use of persisted data
Working at a client site, that in itself is good to say, I ran into a set of circumstances that...
2011-06-13
642 reads
What is the best value for Fill Factor in SQL Server?
Introduction
When an index is created or rebuilt, the fill-factor value determines the percentage of space on each leaf-level page to...
2011-06-13
7,492 reads
Database Documentation with a Data Dictionary Part 2
A continuation of the data dictionary discussion with information about how the documentation is done.
Today I’m going to continue discussing...
2011-06-13
1,494 reads
Moving On To New Challenges
After nearly five and half years, I left NewsGator Technologies for a new position as a Database Architect at Avalara,...
2011-06-13
849 reads
Don't touch that Maintenance Plan Job
Good ol Maintenance plans. With 2005 and beyond we received the glorious SSIS backed Maintenance plans. I love SSIS so...
2011-06-12
1,938 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
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