Meme Monday – Horoscope
Did you know that your sign may have changed? I didn’t – at least not until reading the meme Monday announcement....
2011-07-11
494 reads
Meme Monday: SQL Horoscope: Finding Your Chinese Zodiac
Meme Monday: SQL Horoscope: Finding Your Chinese Zodiac
Chinese Zodiac Figures by Joe Ledbetter
It’s time for July’s Meme Monday post, and...
2011-07-11
2,511 reads
July 21 Data Arch VC Meeting: Gaurav Aggarwal on Microsoft – Readying on “Hadoop”
July 21 Data Arch VC Meeting: Gaurav Aggarwal on Microsoft – Readying on “Hadoop”
Subject:Microsoft – Readying on “Hadoop”Start Time:Thursday, July 21, 2011...
2011-07-11
1,101 reads
Environment variable in SSIS not being recognized
If you are using environment variables in SSIS when using package configuration, chances are you will run into a situation...
2011-07-11
2,114 reads
Meme Monday SQLstrology – Table Valued Zodiac Function
It’s Meme Monday time! Our topic is SQL Horoscopes, or more catchily, SQLStrology.
We’re going to have to figure out what astrological...
2011-07-11
952 reads
SQLSaturday Round Table at the PASS Summit (Early Reminder)
Once again this year we’ll be holding a meeting open to all SQLSaturday event leaders and key team members (and...
2011-07-11
618 reads
Subtle Errors When Using Dates-Part 1
I was reviewing some code recently that has been in production for a while and I saw something like this:
set...
2011-07-11
593 reads
Striping Backups in SQL Backup Pro
There are times you really do want to stripe backups across multiple files. If you have a short backup window,...
2011-07-11
2,299 reads
Meme Monday in July - PearlKnows All
It’s time for July’s Meme Monday, and below is my entry, Star date 07:11:11. Started by Twitter|@SQLRockstar, Thomas LaRock, today’s...
2011-07-11
1,263 reads
Can you delete from a view?
I have seen this question come up several times over the last few months. Can you delete from a view?...
2011-07-11
57,700 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