This afternoon I tweeted that a new Query Store related stored procedure I created is available: sp_WhatsupQueryStore.This blog post goes...
2016-12-01 (first published: 2016-11-24)
2,588 reads
A semi-additive average? What exactly are you trying to calculate? Let me explain first. A semi-additive measure is a measure...
2016-11-24
1,770 reads
It’s Thanksgiving again here in the United States. Throughout the years, the IT community has been awesome. I have been...
2016-11-24
408 reads
AdvertisementsAlwaysON database not synchronizing mode SQL service account change
Suddenly, one of our alwaysON server databases are went not synchronizing mode.
Errors...
2016-11-24
2,612 reads
For this post I want to show you how I recovered to a LSN where I did do this on...
2016-11-24
645 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-11-23
660 reads
In this post I will show a procedure to configure Integration Services in a SQL Server 2016 Cluster.Clustering Integration Services is...
2016-11-23
594 reads
So you want to do some tuning, but you’re not sure how to test a query on it’s performance. Not...
2016-11-23
1,362 reads
I while back as part of a T-SQL Tuesday post I created HAL0001, then later HAL0002 with a long-term goal...
2016-11-23
483 reads
Last Wednesday I got very excited by Microsoft’s announcements about the addition of features to standard edition and the public preview...
2016-11-23
925 reads
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Comments posted to this topic are about the item Split Large Queries in Athena...
Comments posted to this topic are about the item 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