Reblog: April 5 to April 11
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-04-12
405 reads
StrateSQL
Entertainment for the Traveling Consultant (UltraViolet Review)
Like many of us, I have a collection of favorite movies. These include Ghostbusters, Stripes, Serenity, and dozens more. I...
2013-04-11
776 reads
I See BI People
A tweet from Ted Krueger (Blog | @Onpnt) this morning…
I’m surrounded by BI people!!!!#passbac
— Ted Krueger (@onpnt) April 11, 2013
inspired a little creativity…
You...
2013-04-11
776 reads
T-SQL Tuesday – Love For Presenting – #TSQL2sDay
This month, Bob Pusateri (Blog | @SQLBob) is running T-SQL Tuesday on presenting. T-SQL Tuesday is a monthly blogging event where a number...
2013-04-09
571 reads
Chicago SQL Saturday (#SQLSat211) Is This Weekend
The Chicago SQL Saturday is coming up this weekend on Saturday, April 13th. If you are waiting until the last minute...
2013-04-08
521 reads
Last Weeks Top “Reading” Links #27
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-04-08
488 reads
Presentation Materials “Discovering the Plan Cache” #SQLSat206
This past weekend, I took a quick trek into the land of beer and cheese for the second annual Madison...
2013-04-08
603 reads
Madison SQL Saturday (#SQLSat206) Is This Weekend
Crack a beer and melt the cheese, the Madison SQL Saturday is this weekend. Don’t wait any longer because you...
2013-04-02
494 reads
April 2013 – Monthly SQL Server Checklist
After working on this monthly checklist for over a year, I’ve recently discovered that there isn’t anything that we should...
2013-04-01
549 reads
Last Weeks Top “Reading” Links #26
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-04-01
446 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