An interview with me
The other day I received an email asking for some help with a school project. Would I please answer some...
2016-12-15
465 reads
Master Data Services Error – Missing Temp Directory
I recently had to install SQL Server 2016 again on my Windows 10 machine. This also meant that I had...
2016-12-15
2,022 reads
sp_WhatsupQueryStore v1.2 available
sp_WhatsupQueryStore v1.2 has just been released!
In this new version additional parameters are added to control what information is returned and...
2016-12-15
456 reads
Zip Files in SSIS
Of the very many things SQL Server Integration Services does well, one of its shortcomings is that it does not...
2016-12-15
401 reads
Treat Yourself to a Training Christmas Present
Its the week before Christmas. Party season is in full swing. Its a time for reflection on the year gone...
2016-12-15
454 reads
CHECKDB and Page Restoring from SSMS
Did you know that you can run DBCC CHECKDB (WITH PHYSICAL_ONLY) and issue page restores from SSMS (SQL Server Management...
2016-12-15
485 reads
This Week in Data – Episode 16 (Top 5 Reasons You Need a Data Warehouse)
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-12-14
433 reads
What is HTAP?
I have been seeing the term “HTAP” mentioned a lot recently, and I thought I would briefly explain the term....
2016-12-14
340 reads
Reminder – Geek Sync Today!
Today (December 14, 2016) at 12 PM Eastern I’m giving a webinar on preparing for your SQL Server farm for the...
2016-12-14
380 reads
SSIS Package Validation in the Catalog
Built into the SQL Server Integration Services catalog is the ability to run a validation without actually executing the package....
2016-12-14
689 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