Thank you Triangle SQL Server User Group
Thank you TriPASS for a great SQL Server Users Group session tonight! Thank you all for attending, and your questions...
2013-04-24
703 reads
Fargo SQL Saturday (#SQLSat175) Schedule Is This Weekend
We are down to the last few days before first SQL Saturday in Fargo. It’s been some work pulling it...
2013-04-23
504 reads
PowerSQL – Database Backup Report across all Servers – Centralized Approach
This topic provides and describes the quickest way to find when and what databases are being backed up recently.Backups are...
2013-04-23
1,068 reads
snippet designate a certain time of the day in getdate()
Snippet to designate a certain time of the day to evaluate in the current day. If you need to limit a...
2013-04-23
361 reads
Restoring Azure SQL Database to a Local Server
In last week’s post, I talked about the steps required to backup a Azure SQL Database. That post leaves us...
2013-04-29 (first published: 2013-04-23)
6,666 reads
Industry Expert Interview
I don’t know if I would consider myself an industry expert, but hey, it says it on the Internet, so...
2013-04-23
1,009 reads
Review of The Way
The Way, starring Martin Sheen and directed by Emilio Estevez has been on my want to watch list for a...
2013-04-23
678 reads
Speaking at the 2013 Carolina Code Camp
On Saturday, May 4, the Enterprise Developers Guild in Charlotte will hold their annual Carolina Code Camp. There's a number...
2013-04-23
885 reads
Service Application Architecture
Hello Friends,
As discussed in my previous blog the new architecture of Service Application in 2010. Today I am here with...
2013-04-23
896 reads
Force installation of 64-bit ACE OLE DB provider
Anyone working with SSIS and Excel probably had the following issue: you are creating an SSIS package using an Excel...
2013-04-25 (first published: 2013-04-23)
13,158 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