Organizing a SQL Saturday – Part 2 – The Team
A lot of these types of events are pulled together by the local user group. If there is none, it...
2016-08-31
732 reads
The new Data Migration Assistant has been released!
Monday Bob Ward (b/t) announced on twitter that the new Data Migration Assistant had been released.
First things first the DMA...
2016-08-31
980 reads
Sql Server - Find and Replace a value across all tables in database
Find and Replace a value across all tables in database
In my project I faced this problem due to typing mistakes....
2016-08-31
586 reads
Sql Server - Monitoring the Performance of All Stored Procedures
Monitoring the Performance of All Stored Procedures
Every Project suffer from this problem, over the time they
have developed many stored procedure...
2016-08-31
466 reads
Sql Server - Monitoring the Performance of All Stored Procedures
Monitoring the Performance of All Stored Procedures
Every Project suffer from this problem, over the time they
have developed many stored procedure...
2016-08-31
595 reads
Finding out Who’s Touching Your Database at DevConnections
I’ve got a session this fall at the IT/DevConnections conference (Oct 10-13, 2016) called “Who’s Touching My Database?” This is...
2016-08-30
855 reads
Benchmark Azure SQL Database Wait Stats
Today, I want to focus on how we can monitor wait statistics in an Azure SQL Database. In the past,...
2016-08-30
1,044 reads
Events By Feature
Within the world of SQL Server there are a few things one can be certain of - things will change. This is true of the features in SQL Server....
2016-08-30
8 reads
Events By Feature
Within the world of SQL Server there are a few things one can be certain of – things will change. This...
2016-08-30
822 reads
Turbo LogShip 1.0 Released
Earlier this year, I wrote a long post about log shipping. One of the key points I mentioned was how slow restoring can be for a read only log...
2016-08-30
12 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