SQL Server “Denali”: New Certifications
According to the post SQL Server “Denali” Experts–We Need You! that asks for your feedback on the Microsoft certifications for the...
2011-07-20
1,729 reads
Blog Posts
SQL Server 2008 SP2 cumulative update 5
AdvertisementsSQL Server 2008 SP2 10.50.2418.0 latest cumulative update 5 available now. You may download and test it.
Cumulative Update 5 for SQL...
2011-07-20
717 reads
SQL Server Denali Installation Change
Tonight I took my first crack at getting SQL Server Denali up and running on my machine.From what I had...
2011-07-20
1,416 reads
Upcoming Webinar on Using SQL Monitor in the Real World
Recently at SQLServerCentral.com, I have been running a series of articles called the SQLServerCentral.com Best Practices Clinic, which describe how...
2011-07-20
533 reads
A Big Milestone-SQLSaturday #100
Just announced yesterday, SQLSaturday #100 will be held in Brazil on November 26, 2011. Just a little over four years...
2011-07-19
776 reads
A Guest at the Ranch
From the other side of the world, I had a guest at the ranch today.
Pinal Dave, a friend from...
2011-07-19
824 reads
Denali–IIF and CHOOSE
In Denali CTP3, we have a new of new functions to play with. For this post, im going to focus...
2011-07-19
811 reads
Knowing Someone Makes a Difference-Part 1
I’ve put a lot more emphasis on networking in the last few years and I’ve always considered it an investment,...
2011-07-19
621 reads
SQL in the City (London) is a Great Success
This is what my audience looked like from the stage just before I started speaking at the first of my...
2011-07-19
997 reads
SQL Server – SET STATISTICS [IO|TIME] ON
My colleagues and I often joke around with “If it takes less than a second, then it’s okay!”. The reason...
2011-07-19
1,484 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