My Guide to Passing MCTS Exam 70-432
A reader wrote in to me last weekend regarding the MCTS Exam 70-432 (SQL Server 2008, Implementation and Maintenance).
Hi John,
I...
2011-09-05
2,402 reads
Blog Posts
PASS 2011 Countdown – 5 Weeks To Go
We are now 5-weeks from this years PASS Summit. It’s time to start getting ready for the event. Hopefully, you...
2011-09-05
862 reads
SQL Education
They always used to tell us that education is important.
Education is (They said) key, in fact. We as a technical...
2011-09-05
471 reads
SQL Server 2011 “Denali”: Give feedback and win nice gifts
Microsoft SQL Server guys extended periods for Denali’s feedback on Microsoft Connect. And they motivates with really nice gifts for...
2011-09-05
648 reads
The Principle of Least Privilege – Skill #3
This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for...
2011-09-05
5,543 reads
When technology works.
Living in the South East has it perks with the abundant rivers, lakes, streams, mountains, and friendly people. It also...
2011-09-05
419 reads
Youngest MCM in the world?
As part of my MCM preparation (Have to study aggressively at least for next 2 years) , I have downloaded almost all readiness...
2011-09-05
1,502 reads
OT: Rant About Mail-in Rebates For Computer Hardware
As you may know from reading my blog, I buy quite a bit of computer hardware components from places like...
2011-09-04
737 reads
PASSion Award Nominations
PASSion Award
One of the things that makes PASS a successful organization is the volunteers. To show it’s appreciation for these...
2011-09-04
1,502 reads
2011-09-03
357 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