Advice for MAXDOP setting
This post is for the MAXDOP option – how to set it in a SQL Server instance. The option is discussed much...
2015-10-16
205 reads
PASS Summit 2015 Presentations
I am proud to be offering several training opportunities at the upcoming PASS Summit in Seattle, WA during the week...
2015-10-16
593 reads
020 – A Foolish Decision - Syndication – WaterOx Consulting
Making Foolish Decisions In WOxPod!, episode # 020– “A Foolish Decision” I announce a foolish decision I recently made, and how...
2015-10-16
460 reads
Advice for MAXDOP setting
This post is for the MAXDOP option - how to set it in a SQL Server instance. The option is discussed much...
2015-10-16
881 reads
The Whirlwind That Is October – Part 1
October has been such a whirlwind of PASS activity for me. Two SQL Saturdays and the PASS Summit. This post...
2015-10-16
506 reads
Reading Session Data from Memory
In this article, I introduce the topic of reading session data from memory along with some of the pitfalls and some words of caution.
Related Posts:
How to: File Target use...
2015-10-16
27 reads
Reading Session Data from Memory
In the last few articles I took you through a progression of working with the event_file target from the most...
2015-10-20 (first published: 2015-10-16)
1,660 reads
Dir2Dac and github2dacpac - create dacpacs from script folders or the internet
I like writing go (golang not the batch separator) and one of the things that I like is that if...
2015-10-16
912 reads
Dir2Dac and github2dacpac - create dacpacs from script folders or the internet
I like writing go (golang not the batch separator) and one of the things that I like is that if...
2015-10-16
21 reads
Dir2Dac and github2dacpac - create dacpacs from script folders or the internet
I like writing go (golang not the batch separator) and one of the things that I like is that if...
2015-10-16
51 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