SQL Saturday Pensacola
I know it has been almost a month since I posted last and this is not really a “real” post,...
2011-06-01
435 reads
Re-Focusing the Blog a Bit
In recent weeks I've strayed pretty much all over the map with respect to topics. I have another blog, the...
2011-06-01
752 reads
June Question: How Do You Monitor Your SQL Servers?
As DBAs, one of our biggest responsibilities is to monitor our SQL Servers to ensure they are performing as expected....
2011-06-01
1,252 reads
SQL Exercise During Candidate Interview Process
A discussion of how BPS uses a SQL exercise for candidates and why it is helpful.
At the Boston Public Schools,...
2011-06-01
2,713 reads
Start All Your Meetings in Pole Position
Let’s face it, a lot of us don’t enjoy attending meetings and can often find them to be a bit...
2011-05-31
1,832 reads
Free SQL Exam cram sessions from Microsoft.
G’day,
I’m a big fan of maintaining and updating your technical skills, but sometimes its difficult to measure your ability at...
2011-05-31
2,949 reads
Taking It to the Extreme: SQLCLR and Parallelism - a NYC event coming soon!
Here’s another awesome SQL event coming to New York City. (Keep reading for your discount below!) It’s already getting hot...
2011-05-31
2,361 reads
An Unexpected Service Gotcha
Recently I was participating in a round of storage rearranging with a client (aka the storage dance) which consisted of...
2011-05-31
1,570 reads
SQLSaturday #85 in Orlando!
It’s that time of year again, actually a little earlier than in previous years as we’ll be holding our fifth...
2011-05-31
1,499 reads
Use Connections Properly in an SSIS Script Task
There are lots of scenarios in SSIS where you'd want to use a connection within a Script Task. Unfortunately, the closest help documentation - the comments inside the Script...
2011-05-31
15 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