When was the Last Time You Removed an Index Because it was Never Used?
Indexes can be great for boosting the performance of a query, but if an index is never used, it can...
2011-08-11
1,163 reads
Blog Posts
Call for Speakers for the SQL Track at the Tallahassee Code Camp
The annual Code Camp is coming up on October 1st in Tallahassee and our local SQL group is trying to...
2011-08-10
800 reads
Denali & CTP 3
I have Denali installed on a virtual machine on my laptop and I’m working through evaluating it. Actually, I’m working...
2011-08-10
669 reads
Excel Services in SharePoint 2010 Webinar Recording Is Up
First of all if you came out to my webinar this morning let me say a huge thank you! I...
2011-08-10
649 reads
See the New Logo and Graphics for SQLSaturday
Officially launched today, it’s been a project that took a while to bubble to the top, but we’ve done an...
2011-08-10
669 reads
SQL MCM Training – Day 2
Today's day was Jonathan Kehayias days, and it was pretty impressive. Jonathan covered
the following 3 modules, and he can speak...
2011-08-10
1,057 reads
SQL Server “Denali”: Distributed Replay
Replaying multiple threads of a captured trace in SQL Profiler is difficult, and you are limited to replaying the workload from...
2011-08-10
1,601 reads
T-SQL Tuesday #21 – Bringing Ugly Back
T-SQL Tuesday #21 – Bringing Ugly Back
T-SQL Tuesday #21 - I'm Bringing Ugly Back
This blog entry is participating in T-SQL Tuesday #21,...
2011-08-10
1,097 reads
T-SQL Tuesday #21 - Yes, Today is Wednesday!
T-SQL Tuesday #21 - A Day Late and Totally Full of It
Holy Crap! What in the world are we talking about...
2011-08-10
1,867 reads
T-SQL Tuesday (er, Wednesday): Crap Code
Ok, I have two admissions that I must bare to the world in this post. The first is that I’ve...
2011-08-10
1,273 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