Getting Started with PowerBI: Building Graphs (Part 3)
This is part 3 of the Getting Started with Power BI series. Power BI is a powerful reporting and dashboarding...
2017-02-16
180 reads
Deadlock on ALTER DATABASE
I had an interesting problem recently. A database was stuck in single user mode. How exactly was it stuck you...
2017-02-16
1,430 reads
Managing Bad Data
In the last post in my ongoing series about ETL best practices, I discussed the importance of error handling in ETL...
2017-02-21 (first published: 2017-02-16)
2,209 reads
True story: Encryption in progress stuck
Working with a couple of databases that needed TDE I noticed when I enabled one of them that it was...
2017-02-16
378 reads
Resolution of Database Consistency Error in SQL Server
There are so many facilities and amenities in SQL Server along with built-in methods, which assist users in some bad...
2017-02-16
1,947 reads
PowerShell Virtual Group of PASS February Newsletter
We had a schedule conflict so today’s meeting will be pushed until next Wednesday. However, we have a last-minute meeting tonight (this afternoon, tomorrow, whichever time zone you’re in)....
2017-02-15
11 reads
PowerShell Virtual Group of PASS February Newsletter
We had a schedule conflict so today’s meeting will be pushed until next Wednesday. However, we have a last-minute meeting tonight (this afternoon, tomorrow, whichever time zone you’re in)....
2017-02-15
23 reads
PowerShell Virtual Group of PASS February Newsletter
We had a schedule conflict so today’s meeting will be pushed until next Wednesday. However, we have a last-minute meeting...
2017-02-15
493 reads
Upcoming list of webinars
SQL folks, upcoming list of webinars from SQL PASS.
Webinar title / Registration link / more infoSpeakerDate / Time"Why Your Data Type Choices Matter" https://attendee.gotowebinar.com/register/4226815545680860675Andy...
2017-02-15
258 reads
Viewing container logs
I’ve been going over some demos for a presentation that I’ll be giving this year and I thought I’d write...
2017-02-15
434 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