Webcast Tomorrow - Dynamic SSIS: Using Expressions and Configurations
Join me tomorrow at 1:00pm CST as I present "Dynamic SSIS: Using Expressions and Configurations" for the PASS DBA virtual...
2010-01-12
1,029 reads
TSQL Tuesday #2
I’ve wracked my brain for some bit of puzzle that I could present as part of TSQL Tuesday #2 and I...
2010-01-12
1,130 reads
IN vs INNER JOIN
Often in forum threads discussing query performance I’ll see people recommending replacing an INNER JOIN with an IN (or recommending...
2010-01-12
21,727 reads
We Interrupt Your Regular SQL Blogging For This Announcement…
EXEC sys.sp_addextendedproperty
@name = N'IsWifePregnant',
@value = N'True',
@level0type = N'USER',
@level0name = N'Kendal.VanDyke' ;
EXEC sys.sp_addextendedproperty
@name = N'ExpectedDueDate',
@value = N'August 2010',
@level0type = N'USER',
@level0name...
2010-01-12
800 reads
Setting Goals for 2010
Most people set their New Year resolutions for the new year at this time. We know from history that many...
2010-01-12
362 reads
Would Third-party Product Driven/Vendor Sessions Benefit User Groups and Community Events?
In the the couple of years I have been involved in the SQL Server community I have noticed that there...
2010-01-12
791 reads
Video Featured on SQLShare
I didn’t have a chance to blog this yesterday (January 11, 2010), but my most recent video, Dynamic SQL Using...
2010-01-12
480 reads
T-SQL Tuesday #2 – Data Conversions
Adam Machanic started the idea of a blog party last month, getting people to write about date and time issues...
2010-01-12
1,695 reads
January OPASS Meeting Tonight
Tonight is the January meeting for OPASS and we have a great schedule for the evening.
Robert Hurwitz a developer for...
2010-01-12
389 reads
T-SQL Tuesday #2 – Data Conversions
Adam Machanic started the idea of a blog party last month, getting people to write about date and time issues...
2010-01-12
525 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