See you at SQL Saturday Baton Rouge 2015!
SQL Saturday is a global event to bring Information Technology speakers and professionals together for a community-driven, community-attended free day...
2015-07-19
597 reads
Merge statement- A simple way for DML TIP#105
When, I first saw this statement a Hindi proverb come to my mind which is “1 teer 2 nishane” . The...
2015-07-18
963 reads
SQL Server Infernals – Circle 5: Inconsistent Baptists
There’s a place in the SQL Server hell where you can find poor souls wandering the paths of their circle,...
2015-07-23 (first published: 2015-07-17)
2,945 reads
012 – Carlos Chacon - WaterOx Consulting
Someone worth getting to know in the Mid-Atlantic region! In WOxPod!, episode...
The post 012 – Carlos Chacon appeared first on WaterOx...
2015-07-17
568 reads
WaitForSql (to start)
In the spirit of having apps that do just one thing I have put a really small .net app on...
2015-07-17
526 reads
WaitForSql (to start)
In the spirit of having apps that do just one thing I have put a really small .net app on...
2015-07-17
50 reads
WaitForSql (to start)
In the spirit of having apps that do just one thing I have put a really small .net app on...
2015-07-17
34 reads
Validating Cluster Instance Owner with Powershell
A few weeks ago, for TSQL Tuesday, I wrote about how I used Powershell to manage failing over clusters. At work,...
2015-07-17
1,019 reads
Murder and XE Train in Louisville
Bringing years of experience together in two all day workshop sessions.
Related Posts:
Seattle SQL Pro Workshop 2017 October 19, 2017
Finding Installed Event Sessions December 31, 2018
Sharepoint Diagnostics and...
2015-07-17
7 reads
Murder and XE Train in Louisville
I am about to set sail on a new venture with my next official whistle stop. This year has been...
2015-07-17
860 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