SQL Server 2008 R2 SP1 Cumulative Update 2
Microsoft has released SQL Server 2008 R2 SP1 Cumulative Update 2, which is Build 10.50.2772.0. I count 14 fixes in...
2011-08-16
1,519 reads
Basic Computed Columns
I ran into an issue recently with a computed column, which I’ve rarely used, so I investigated them and wrote...
2011-08-16
1,987 reads
You Are Allowed to Care About Whatever You Want
I wanted to write this because its often overlooked. I care about things that may not interest you, things that...
2011-08-16
576 reads
Going Big with SSDs
Nimbus Data just sold 100TB of SSDs to eBay
I found a report recently that eBay had implemented 100TB of SSD storage from Nimbus...
2011-08-16
935 reads
Top 5 Oracle Nuances I learned Today
I don’t do much with Oracle – at all. Once in a blue moon, I find a little project to do that might involve Oracle. I have never put...
2011-08-16
16 reads
Top 5 Oracle Nuances I learned Today
I don’t do much with Oracle – at all. Once in a blue moon, I find a little project to do...
2011-08-16
2,124 reads
Compiles and recompiles
I want to spend some time over the next few months looking at query compilation and the plan cache, and...
2011-08-16
3,847 reads
SSIS - Inferred Member Insert in Fact Table Load
Recently while working on a different solution for loading inferred member solution in our fact table load I ran into...
2011-08-16
2,954 reads
Steel City SQL User Group
Tonight I will be doing a presentation on TEMPDB to the Steel City SQL Users Group in Birmingham AL. I...
2011-08-16
552 reads
Announcing the upcoming Colorado GiveCamp
What is a GiveCamp?
GiveCamp is a weekend-long event where technology professionals from designers, developers and database administrators to marketers and...
2011-08-16
523 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