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
Blog Posts
How Should We Pay People?
It’s an interesting article on how to pay people from Dan Ariely at Business Week. It’s a look at some...
2011-09-27
1,168 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
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
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
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
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
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
SSIS Child Errors in Parent Package
If you have a parent package that is looping through a set of files and calling child packages and want...
2011-09-27
2,746 reads
Start daily programs – More n00bz fun with #Powershell!
When I get in to work in the morning, I like a good cup of coffee waiting for me, a...
2011-09-27
1,215 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 Pasar Tanah Abang Tlp:08218520153
WhatsApp CS 628218520153 Jl. KH Fachrudin 36 Blok D/23, Kp. Bali, Kecamatan Tanah Abang,...
Split Large Queries in Athena with a Simple Modulo Trick
Comments posted to this topic are about the item Split Large Queries in Athena...
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