Thoughts on the 2016 PASS Summit
I’ll have several more posts this week on specific activities at the Summit, but wanted to start with how the...
2016-11-07
378 reads
MVP No More
Back in September I received a call from my MVP lead that I wasn’t being renewed. Not a big surprise,...
2016-11-07
386 reads
Comparing xSQL Schema Snapshots
Applies to: xSQL Schema
Compare v7.0.0 – 9.0.2
Before I develop a scenario where
xSQL Schema Compare snapshot comparison is necessary let’s explain what xSQL
Schema snapshots are. An xSQL Schema snapshot is...
2016-11-07
22 reads
Comparing xSQL Schema Snapshots
Applies to: xSQL Schema Compare v7.0.0 – 9.0.2
Before I develop a scenario where xSQL Schema Compare snapshot comparison is necessary let’s...
2016-11-07
365 reads
Writing More This Month
I haven’t written much in a while, having had to put more time into both personal and professional obligations over...
2016-11-07
369 reads
Query Store Instance Dashboard
Last week I shared my custom Query Store Dashboard that can be used to view additional performance information that isn’t...
2016-11-07
2,141 reads
Implementing Fuzzy Sets in SQL Server, Part 5: The Mystery of the Missing Left Join
By Steve Bolton
…………Information on set operations like complements, intersections and unions is plentiful in the literature on fuzzy sets, which...
2016-11-07
797 reads
Mastering Index – Index on Computed Columns
This
article is the part of series Mastering Index, in this particular article
we will be exploring Index on computed
columns. Take a look...
2016-11-07
571 reads
Copying your SQL Database
If you have created a SQL Database in Azure (PaaS) and need to make a copy of it on the...
2016-11-07
409 reads
Knowledge vs Ability
Knowledge and ability, they are very inter-related. We born with only survival ability, ability to eat and drink, that’s pretty...
2016-11-07
1,404 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