Speaking at SQLSaturday Sacramento!
I’m proud to announce that I will be speaking at SQL Saturday Sacramento on July 23th 2016! This will be my...
2016-07-15
433 reads
Azure SQL Database waits you should be aware of…
I’ve been using Microsoft’s cloud database for some time now. I’ve had a few customers with various performance problems and...
2016-07-15
2,217 reads
Resolving PolyBase Installation Errors in SQL Server 2016
One of the exciting new features you may want to explore in SQL Server 2016 is PolyBase. However, as I...
2016-07-15
1,433 reads
SQL vs NoSQL
Introduction
Despite the traditional relational DB world, there’s also a trend for NoSQL. The NoSQL databases that enable storing unstructured and...
2016-07-15
4,652 reads
GIT Learning Resources
I’ve spent most of my career using VSS and TFS, mainly because that’s what was being used. Better any source...
2016-07-15
442 reads
TGI Friday (Live Blog Day 4)
Its been long but productive week at Tree Tech
This week I’m teaching Learning Tree’s course 2108 SQL Server Database Administration in the...
2016-07-15
417 reads
SQLServerZest is now DataGinger!
We are happy to announce the birth of DataGinger. Starting today we officially re-branded ourselves as DataGinger.com (previously SQLServerZest.com). The...
2016-07-15
414 reads
Introduction to Power BI Desktop – Recording Now Available
Thank you to everyone that attended this past Tuesday’s webinar hosted by Pragmatic Works called Introduction to Power BI Desktop....
2016-07-15
620 reads
Descriptive Statistics with SQL and R – 1
I started my re-discovery of statistics with an introduction here. This second post is about descriptive statistics – very basic, simple...
2016-07-14
1,120 reads
SQL Server CTE – Back to Basics
Of all the fundamental concepts within SQL Server, this one drives me a bit batty from time to time. Think about that statement for just a moment.
Related Posts:
T-SQL Tuesday...
2016-07-14
19 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
ALAMAT BCA KCU SURYOPRANOTO Tlp:08218520154
WhatsApp CS 628218520154 Jl. Suryopranoto No.40, RT.12/RW.7, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat,...
Alamat BCA KCP Sentral Cikini Telp:08218520154
WhatsApp CS 628218520154 Jl. Pegangsaan Timur No.1, Cikini, Kec. Menteng, Kota Jakarta Pusat, Daerah...
Alamat BCA KCP Pintu Air Telp:08218520154
WhatsApp CS 628218520154 Jl. Pintu Air Raya No.36 Q, RT.6/RW.1, Ps. Baru, Kecamatan Sawah...
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