T-SQL Tuesday #108: New Horizons Beyond SQL Server
There comes a point in one's career when a change is requisite. Big or small there always seems to be a tipping point that mandates some sort of change....
2018-11-13
9 reads
Blog Posts
Why did my execution plan change?
As a SQL Server DBA it is important to understand why and how the SQL engine works. Understanding as much...
2018-11-13
2,885 reads
Load and run custom T-SQL scripts in SSMS via Snippets
If you work with SQL Server on a daily basis, it is very likely you have a lot of custom scripts you have to execute frequently, maybe you have...
2018-11-12
20 reads
Load and run custom T-SQL scripts in SSMS via Snippets
If you work with SQL Server on a daily basis, it is very likely you have a lot of custom...
2018-11-12
365 reads
Notes From the 2018 PASS Summit (v20)
This was the 20th PASS Summit, a decent milestone! Interesting to pause and think, what will the Summit look like...
2018-11-12
274 reads
Part 1: Predictive Modeling using R and SQL Server Machine Learning Services
To R or not to R? A few months ago, I asked myself an important question – which language to learn first – R or Python? From my research,...
2018-11-12
35 reads
Part 1: Predictive Modeling using R and SQL Server Machine Learning Services
To R or not to R?
A few months ago, I asked myself an important question – which language to learn first...
2018-11-12
656 reads
Random Pix from the 2018 PASS Summit
A few memories from me. First, a beautiful late arrival view.
My first session feels a little lonely
It started to fill...
2018-11-12
785 reads
Speaking At SQL Saturday DC
I am so excited to announce that I was selected to speak at SQL Saturday DC on December 8, 2018. I will be presenting two sessions, What is Power...
2018-11-12
12 reads
Speaking At SQL Saturday DC
I am so excited to announce that I was selected to speak at SQL Saturday DC on December 8, 2018.
I...
2018-11-12
162 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
ALAMAT BCA KCU SURYOPRANOTO Tlp:08218520154
WhatsApp CS 628218520154 Jl. Suryopranoto No.40, RT.12/RW.7, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat,...
Alamat BCA KCP Sentral Cikini Telp:08218520154
WhatsApp CS 628218520154 Jl. Pegangsaan Timur No.1, Cikini, Kec. Menteng, Kota Jakarta Pusat, Daerah...
Alamat BCA KCP Pintu Air Telp:08218520154
WhatsApp CS 628218520154 Jl. Pintu Air Raya No.36 Q, RT.6/RW.1, Ps. Baru, Kecamatan Sawah...
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