Indexes – Understanding basic types and their components
The biggest problem developers and newer DBAs have with understanding indexes is that you don’t realize when you’re using the...
2013-05-18
1,459 reads
Software Design and Schizophrenic Windows 8 Part 2
I know it’s not schizophrenic, but that sounds better. It’s really a split personality.
I wrote recently about Windows 8 and...
2013-05-17
1,170 reads
Windows, RIP (1992 – 2013)
Today is a very sad day for me. My love, my dear Windows has passed away. We were together for...
2013-05-17
1,087 reads
Certifiable?
I have recently begun to contemplate pursuing the MCSA Certification. I have been working with SQL Server for almost 20...
2013-05-17
634 reads
SQLSaturday #220 Atlanta
From the tweets, it looks like there will be about 800 attendees sitting in on 11 different tracks with 5...
2013-05-17
518 reads
Indexes – Unused and Duplicates
Indexes aren’t free, and many databases end up with unused indexes. Every time you make any update to a table...
2013-05-16
1,736 reads
SQLSaturday Redmond(SQLSat212) is almost here…Will you be there?
This is my first SQLSaturday and I’m super excited to attend this event.
SQLSaturday’s are always a great opportunity to learn something exciting,...
2013-05-16
636 reads
Virtualization Networking Tips for SQL Server 2012 AlwaysOn
A while back Kendal Van Dyke (b | l | t) asked me a great question regarding the ideal VMware vSphere networking...
2013-05-16
1,535 reads
Parameterizing an Excel Spreadsheet
I’ve had a few discussions in the past week about not only including Excel spreadsheets on PerformancePoint dashboards, but specifically...
2013-05-16
3,030 reads
When the person you hire is not the person you hire
This is something I just heard about recently, but then experienced it for myself.
This story was told to me: A...
2013-05-16
894 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