Double Hop of Doom
I recently had to battle through THE DOUBLE HOP OF DOOOOOMMM!! It was a very rewarding experience and I think...
2011-06-20
4,433 reads
Indexes Aren’t Always the Answer
There’s a tendency to think all problems can be solved with an index or two (or partitions, or other performance...
2011-06-20
987 reads
Evaluating Sessions You Attend
I have seen more than a few posts about feedback that speakers get from sessions in the last couple months....
2011-06-20
1,430 reads
Code Snippet for an SSIS DataFlow Performance Wiretap
I was recently tweaking a few Data Flows, and settled on a very small, but very useful script to help record execution timing inside the flow.
Decomposition Is Time...
2011-06-20
17 reads
Code Snippet for an SSIS DataFlow Performance Wiretap
I was recently tweaking a few Data Flows, and settled on a very small, but very useful script to help record execution timing inside the flow.
Decomposition Is Time...
2011-06-20
17 reads
Make the Optimizer Work Harder
One of my favorite indicators for whether or not you have a good execution plan is when you see the...
2011-06-20
2,803 reads
Poor man’s SQL monitor
Here is quick tip that can help you track SQL Job and Alert notifications in Microsoft Outlook. Many of you...
2011-06-20
938 reads
Non use of persisted data – Part deux
In my last blog I showed how persisted data may not be used if you have used the base data...
2011-06-20
539 reads
Difference between Checkpoint and LazyWriter
Was thinking about to write this blog for quite some time. CheckPoint Lazy Writer 1. Flush dirty pages to Disk...
2011-06-20
1,040 reads
Difference between Checkpoint and LazyWritter
Was thinking about to write this blog for quite some time. CheckPoint Lazy Writer 1. Flush dirty pages to Disk...
2011-06-20
554 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