Installing the SQL Clone Agent and the VC++ Runtime
I was trying to get SQL Clone working recently and had an issue with the Agent. If you haven’t looked...
2017-01-13
651 reads
New Pluralsight Course – LFCE: Advanced Network and System Administration
My new course “LFCE: Advanced Network and System Administration” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to...
2017-01-13
9 reads
New Pluralsight Course – LFCE: Advanced Network and System Administration
My new course “LFCE: Advanced Network and System Administration” in now available on Pluralsight here! If you want to learn about the course,...
2017-01-13
690 reads
Friday Reading 2017-01-13
Ahh, is it really Friday the 13th?!! So before Jason gets me, I’ll be reading…
A whole day of PowerShell & SQL
Join...
2017-01-13
349 reads
Checking Time Zones in SQL Server
I was building some basic queries around time zone manipulation and I am happy to say that I enjoyed myself...
2017-01-13
1,337 reads
SQL Server: How to backup and replace text in all search string matching Stored Procedure(s)
Table of Contents
Problem Statement:-Solution:-Generate script for matching search string of all SP’s
Using sp_helptextUsing system view sys.proceduresGenerate modified SP’s scriptCreate Linked...
2017-01-12
1,351 reads
Vote for @SQLBits Sessions (pick me, pick me)
The SQL Bits sessions are out and it’s time to vote for me. Well, vote for the sessions you’d like...
2017-01-12
464 reads
Why won’t my SQL Logins work?
I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a...
2017-01-12
814 reads
Using the PowerShell SQL Provider with SQL Authentication
Whilst having a conversation with Chrissy LeMaire last week about using the SQL Provider. She asked if it could use SQL...
2017-01-12
2,066 reads
Tables can't be compared
"I am trying to compare two databases and xSQL Data Compare has marked all table pairs with a red X and the messages on the output window show something like [16:08:11]...
2017-01-11
32 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