tSQLt Visual Studio Test Adapter
tSQLt Visual Studio Test Adapter What is this? This lets you use Visual Studio to run tSQLt tests easily. Visual Studio has a built in framework for finding and...
2016-08-17
10 reads
Azure SQL Database new performance level
A new performance level for Azure SQL Database was recently announced, called P15. This new offering is more than two...
2016-08-17
702 reads
Go, Go, Golang!
WHAT! Yep, you read that right. I’m building tools in Go. I can hear you now…. But Wes you are a SQL Server guy, a WINDOWS guy! What...
2016-08-17
36 reads
Go, Go, Golang!
WHAT!
Yep, you read that right. I’m building tools in Go.
I can hear you now…. But Wes you are a SQL...
2016-08-26 (first published: 2016-08-17)
1,794 reads
Updates to Azure Data Platform Learning Resources
I’m acting as the curator to a list of Azure Data Platform Learning Resources. It’s speakers and teachers, blogs, articles...
2016-08-17
518 reads
RBAR vs Batch
Many years ago Jeff Moden (of SQL Server Central fame) came up with the concept of RBAR. Row-By-Agonizing-Row. At it’s...
2016-08-25 (first published: 2016-08-17)
2,724 reads
DBCC CLONEDATABASE in SQL Server 2014
In SQL Server 2014 SP2 an interesting new DBCC command was included, DBCC CLONEDATABASE
This command creates a “clone” of a...
2016-08-22 (first published: 2016-08-17)
2,813 reads
Great Value IT Training from @LearningTree #SQLServer - 17th August 2016
This weeks great value IT training deals are in. This being SQL Server blog I would like to draw your...
2016-08-17
400 reads
T-SQL Tuesday #081: Getting Sharper
Getting sharper at JSON through a little experimentation.
Related Posts:
Passion, Challenges, and SQL February 12, 2019
T-SQL Tuesday #097: Learning Plans December 18, 2017
T-SQL Tuesday 109: Influence Somebody Invite...
2016-08-16
11 reads
T-SQL Tuesday #081: Getting Sharper
Sharpen Something
This month I am the host of the TSQL Tuesday blog party. In the invite, which can be read...
2016-08-16
366 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