Speaking at 24 Hours of PASS on September 15, 2010
I will be one of the presenters for the 3rd installment of the 24 Hours of PASS: Summit Preview, which...
2010-08-11
782 reads
24 Hours of PASS: Summit Preview
Registration is open for the second 24 Hours of PASS this year. This one is going to be a preview...
2010-08-11
565 reads
Sharing a Temporary Table
One of the things that I’ve often seen people do is build temp tables to hold data for each connection...
2010-08-11
2,147 reads
SQL Saturday #48, Come One, Come All
SQL Saturday #48 - Columbia, SC, is a little over 7 weeks away (October 2, 2010), so we're picking up the...
2010-08-11
532 reads
SQL Reporting Services - Line Graph with a Vertical Bar
So, I was recently asked if you could display a vertical bar on a line graph to denote the last...
2010-08-11
3,339 reads
R & R
It is once again time for the blog party known as TSQL Tuesday. I am hosting this month and wanted...
2010-08-10
625 reads
The PASS SQL Rally Logo - I Won!
Well not me. It wasn’t my design, but when I went through the entries, this was the one that caught...
2010-08-10
927 reads
August SSSOLV Reminder
Just another reminder about the Las Vegas User Group meeting coming up on August 12th.
Here is the info:
The S3OLV UG...
2010-08-10
482 reads
The PASS SQLRally Logo Winner Is…
With 63% of the total votes our winner is Speedometer! Congratulations to azzam on 99designs and thank you to everyone...
2010-08-10
552 reads
MDX Puzzle #5 - Solution
Again I want to apologize for the slow posting of the solution to this puzzle, but I have been hard...
2010-08-10
588 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