ISNULL() VS. COALESCE()
There are a lot of arguments about which of these to use. In my opinion, they both have their place. ...
2010-02-11
9,072 reads
POTW Webcast with Kevin Kline
Today I'll be tagging along with Kevin Kline for the Quest Pain of the Week webcast. We'll be talking about...
2010-02-11
957 reads
Growing the Pool of SQL Server Speakers
In a nutshell, I’m interested in growing and diversifying the pool of speakers that focus on SQL Server. You might...
2010-02-11
996 reads
A Tale Of Two Execution (Updated)
Update: Scroll to the bottom for more information added after originally posting.
Earlier this week a coworker asked me for help...
2010-02-10
720 reads
Negotiating Salary for a New Job
Slightly off topic, but I’m adding this one to the Modern Resume blog since I think it’s something to be...
2010-02-10
489 reads
Notes from the February 2010 oPASS Meeting
Really rainy in Orlando today, traffic is horrible. We had a higher than usual number of RSVP’s for the meeting,...
2010-02-10
482 reads
February OPASS Meeting Recap
Introduction
Last night we had our February OPASS meeting with Ron Dameron (@RonDBA) presenting on Database Hardening using PowerShell. We broadcast...
2010-02-10
413 reads
T-SQL Tuesday #3: Database Relationships
In my first T-SQL Tuesday submission I thought I'd mention something that we often take for granted when working with...
2010-02-10
464 reads
SQLSaturday #43 Announced!
Greg Larsen is hosting SQLSaturday in Redmond, WA again this year, this time on June 12, 2009. Call for speakers...
2010-02-10
593 reads
Round Two of Insert Benchmark Tests
After seemingly exhausting my physical file layout and instance configuration options in Round One of testing, I decided to “throw...
2010-02-09
543 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
Split Large Queries in Athena with a Simple Modulo Trick
Comments posted to this topic are about the item Split Large Queries in Athena...
Finding Trailing Spaces
Comments posted to this topic are about the item Finding Trailing Spaces
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