Fixing Untrusted Foreign Key or Check Constraint
Untrusted constraints can be found when you alter/drop foreign key relationships and then add them back without the proper syntax....
2016-10-22
1,252 reads
If You Read One Article About Split String in SQL SERVER 2016s Read this One #3
In the Series of SQL SERVER 2016, this is another post. Before Jumping in detail just think if you have...
2016-10-22
965 reads
VMworld Europe 2016 Wrap Up
This past week I had the pleasure of attending our first VMworld Europe conference, held this week at the Fira Gran Via in...
2016-10-21
728 reads
Meet and Greet Data Pros at #sqlsummit
Next Monday night is the networking dinner that Andy Warren and I have put together for the last 6 years....
2016-10-21
498 reads
#RedgateRocks at the PASS Summit
If you are attending the PASS Summit next week in Seattle, and want to attend a fun party on Thursday...
2016-10-21
497 reads
How O’reilly Picks Sessions
Read this and wanted to share as we head to the PASS Summit next week: This is how we do it:...
2016-10-21
433 reads
Notes on Designing an After Hours Event for the PASS Summit
This year we’re trying out two ideas on Thursday night, a networking dinner (of a sort) and game night. I...
2016-10-27 (first published: 2016-10-20)
660 reads
Syncing QA data with Production
Applies to: xSQL Data Compare v7.0.0 and higher
WARNING: this article focuses on the data transfer / synchronization task and does not address operation security issues and sensitive data scrubbing /...
2016-10-20
57 reads
Syncing QA data with Production
Applies to: xSQL Data Compare v7.0.0 - v9.0.0
Nowadays, Quality Assurance (QA) is a very important part of the development process for any...
2016-10-20
646 reads
Creating a Logon Trigger–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-10-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