All the good DBAs backup their databases.
A significant amount of SQL DBAs use Ola Hallengrens maintenance solution to do so.
This...
2017-03-29 (first published: 2017-03-18)
3,062 reads
By David Postlethwaite
David is delivering a talk An Introduction to SQL Server Query Store at SQL Saturday Iceland today - this...
2017-03-18
732 reads
I’m getting excited, and you should as well. Join me at a fantastic conference in the UK this spring. Register...
2017-03-17
508 reads
Sometimes things just don’t make sense.
One of our production servers has 4×8 (4 sockets, 8 core) processors with hyper threading enabled. This...
2017-03-17
878 reads
SQL Server is used widely for the management of database. It is possible that the data gets corrupt due to...
2017-03-17
2,539 reads
This is hardly breaking news, but it’s important to know: when using NOLOCK table hints in SQL Server, it can...
2017-03-17
3,130 reads
Please join the PASS Excel Business Intelligence Virtual Group onn March 22nd 11AM Eastern for Microsoft’s Program manager Alexander Lahuerta....
2017-03-17
518 reads
As this is being posted I’m on my way up to Dublin Airport to catch my flight to Iceland ready...
2017-03-17
299 reads
I wrote a short article on enabling and disabling trace flags. You can read it, but I didn’t really discuss...
2017-03-31 (first published: 2017-03-16)
1,943 reads
Recently, I was tasked with “enhancing” a third party application. This third party application (TPA) outputs a bunch of files...
2017-03-30 (first published: 2017-03-16)
2,288 reads
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
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