Auditing Failed Logins – SQL Server 2008
I wrote about setting up a basic server audit recently. That showed about how a server level audit is set...
2010-05-28
3,556 reads
Importing binary files with SSIS
I have gotten a number of emails over the past few days asking about how I import binary files into SSIS as well as how to improve throughput by...
2010-05-28
21 reads
Importing binary files with SSIS
I have gotten a number of emails over the past few days asking about how I
import binary files into SSIS as well as how to improve throughput by...
2010-05-28
31 reads
Importing binary files with SSIS
I have gotten a number of emails over the past few days asking about how I import binary files into...
2010-05-28
2,498 reads
Book Review: The Yankee Years
The Yankee Years by Joe Torre ($12 @ Amazon) was a gift, and I enjoyed it more than expected. When it...
2010-05-28
1,411 reads
The Truth about SQLPS and PowerShell V2
With the release of SQL Server 2008 R2 there have been claims that sqlps is really PowerShell V1 under the...
2010-05-28
5,550 reads
When did SQL Server start and how long is the downtime window?
This is an old topic, and there have been quite a few blogs (and following comments) that illustrate how to...
2010-05-27
3,748 reads
BI Conference Grocery Shopping Demo
Help enter demonstration data for the Microsoft BI Conference.
Go to the shopping
demo web form and enter some transactions.
No...
2010-05-27
1,446 reads
Challenge 19 – An Explanation of a Query
I have received a number of requests for an explanation of my winning query of TSQL Challenge 19. This involved...
2010-05-27
1,720 reads
SQLSaturday #49 Planning Update
Planning for SQLSaturday #49 – Orlando is on-going and going well especially since we have a good head start. We have...
2010-05-27
484 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
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