24 Hours of PASS Questions
I finally found the time to work through the questions from the 24 Hours of PASS session that I did....
2011-09-27
765 reads
Data Head
Well, it’s official. I am a Data Head. It doesn’t change too much my level of geekiness. But I may have to rethink one of the answers given during...
2011-09-27
13 reads
Data Head
Well, it’s official. I am a Data Head. It doesn’t change too much my level of geekiness. But I may...
2011-09-27
777 reads
SQL University SSIS : Named Pipes -- Producer
Yesterday, I set up the premise for using named pipes in SSIS. Today we are going to get into the...
2011-09-27
703 reads
SQL Saturday in Iowa City This Weekend
In just a few short days, it will be time for SQL Saturday #98 in Iowa City. If you’ve got...
2011-09-27
717 reads
NOT IN or IN?
I have been having a hard time believing my eyes when I noticed that these queries give different results:
1. select...
2011-09-27
781 reads
KB2463332 failed to install
This morning I was working on getting all new inherited SQL Servers patched to current levels of service packs when...
2011-09-27
1,484 reads
workaround for orphaned users
The server principal is not able to access the database under the current security context, is the error message appears...
2011-09-27
404 reads
Missing indexes
One of the most common things I encounter when asked to help with performance problems, is wrong or inadequate indexing....
2011-09-27
1,421 reads
September 2011 SQL Server 2008 Instance Level Diagnostic Queries
Since it is late September, I thought it would be a good time to release an updated set of Diagnostic...
2011-09-27
1,248 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 KCP ITC Roxi Mas Telp:08218520153
WhatsApp CS 628218520153 ITC ROXY MAS, Jl. Kh Hasyim Ashari No.125 Basement 13, RW.8,...
Alamat BCA KCP Sawah Besar Telp:08218520153
WhatsApp CS 628218520153 Jl. Sukarjo Wiryopranoto No.28 C, RT.1/RW.1, Kb. Klp., Kecamatan Gambir, Kota...
Alamat BCA KCP Pasar Tanah Abang Tlp:08218520153
WhatsApp CS 628218520153 Jl. KH Fachrudin 36 Blok D/23, Kp. Bali, Kecamatan Tanah Abang,...
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