Dropping Masking from a Column–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-08-09 (first published: 2016-08-04)
2,090 reads
SQL Server 2016 Cumulative Update 1
On July 25th Microsoft released the first cumulative update (#1) for SQL Server 2016. This is a good reason to...
2016-08-04
337 reads
AlwaysON move database without breaking HADR
AdvertisementsMove database without breaking alwaysON
This post is going to show the database movement from one drive to another drive, without...
2016-08-08 (first published: 2016-08-03)
15,865 reads
Dreaming of SQL Saturday
I’m truly stunned at the responses I received to my post asking how far people have traveled for a SQL...
2016-08-12 (first published: 2016-08-03)
1,424 reads
What’s the difference between LEFT and RIGHT OUTER JOINs?
A DBA walked into a bar, saw a couple of tables, and asked “Can I JOIN you?”
There are several different...
2016-08-03
1,296 reads
Minimizing SQL Server DBCC CHECKDB Performance Impacts
Overview
SQL Server is the most popular relational database management system, which is used by many organizations to maintain their data....
2016-08-03
1,551 reads
SQL Server 2016 – Perform Volume Maintenance
One of the server settings that I always enable when configuring a new instance of SQL is database instant file...
2016-08-03
468 reads
Great Value IT Training early August Update
Its that time of the week when get the latest Learning Tree courses that have been available for £750 plus...
2016-08-03
346 reads
Undocumented Commands
There isn’t really a need to do what I am doing in this blog post but I guess one reason...
2016-08-03
205 reads
DacFxed - Powershell Nugetized DacFx wrapper
Deploying a dacpac from powershell should be pretty easy, there is a .net api which you can use to open...
2016-08-02
890 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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