SQL Server – SET STATISTICS [IO|TIME] ON
My colleagues and I often joke around with “If it takes less than a second, then it’s okay!”. The reason...
2011-07-19
1,484 reads
The SQLSaturday Sensation - Celebrating the 100th Event!
The SQLSaturday Sensation!
Congratulations, Brazil! You are the recipient host country for SQLSaturday #100!! On Saturday, November 26, 2011, when the...
2011-07-19
2,438 reads
A Guest at the Ranch
From the other side of the world, I had a guest at the ranch today.
Pinal Dave, a friend from...
2011-07-19
824 reads
Microsoft SQL Server 2008 SP2 Cumulative Update 5 Released
Microsoft has released Cumulative Update 5 for SQL Server 2008 Service Pack 2. This CU has ten fixes listed in...
2011-07-18
1,582 reads
SQLServerCentral.com Track at SQL Server Connections This Fall in Las Vegas
As has now become a regular tradition, SQLServerCentral.com is providing an educational track at SQL Server Connections (part of DevConnections)...
2011-07-18
2,250 reads
Search Argument Case Study: WHERE the year was 2002…
Content Rating: Beginner, Tips
It’s entirely possible that you’re fiddling with your search arguments too much, and missing out on the...
2011-07-18
815 reads
SQL Server “Denali”: Details on the next version of SSIS
CTP3 of SQL Server Code Name “Denali” was made available recently, and it offers a lot of new features for...
2011-07-18
1,259 reads
Event: NJSQL UG Tomorrow 7/19 - Management Data Warehouse
If you're in the local NY/NJ Tri-State area, and planning on attending, this is a reminder from the New Jersey...
2011-07-18
697 reads
PASS Update #60
I’ve written a lot here, but for June & July (and part of August) I’m trying to just keep the ship...
2011-07-18
655 reads
Presenting Upserts to PASS AppDev VC
Hopefully this crowd knows a little about what they're getting into! John Jakubowski (blog|twitter) has graciously asked me to present on upsert strategies with SSIS. What are "upserts"? A...
2011-07-18
20 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