Polos for SQLSaturday
One of things we've tried to do from the beginning is to provide each speaker & volunteer with a good quality...
2008-09-28
1,360 reads
Blog Posts
SMO Videos on JumpStartTV.com
Last month I got to head out to Orlando and spend a couple of days with Andy Warren and the...
2008-09-28
1,672 reads
Sunday Morning
I woke up early, with my schedule a bit messed up from last week and yesterday. I was tempted to...
2008-09-28
1,431 reads
The New Leader - Why Did I Write This?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-09-28
1,439 reads
The September Energy Update - Why Did I Write This?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-09-28
1,347 reads
Midlands PASS October Meeting - SQL Server MVP Andy Leonard
Speaker: SQL Server MVP Andy Leonard
Midlands PASS Chapter - October 2, 2008 Meeting
The Midlands PASS chapter will hold our normally scheduled...
2008-09-26
1,800 reads
Should He Stay or Should He Go?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-09-26
1,419 reads
Cheap Vacation/Travel Books
As you've probably noticed via the blog I read a lot; technical, fiction, and non-fiction. Reading can be an expensive...
2008-09-25
1,731 reads
Prometheus
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-09-25
1,588 reads
SQL Server 2008 (Verisoni i ri RTM)
Pershendetje te gjithve...edhe perkunder voneses se postimeve te njepasnjeshme ne blog si duket deri me tani jeni njoftuar te gjithe...
2008-09-25
1,830 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