Code Snippet for an SSIS DataFlow Performance Wiretap
I was recently tweaking a few Data Flows, and settled on a very small, but very useful script to help...
2011-06-20
905 reads
Table Backups and the TableArchive Database
A discussion of how a separate database is used for storing table backups.
In a recent article, one of the things...
2011-06-20
908 reads
Presenting Two Sessions at PASS Summit 2011
I found out earlier this week that I was fortunate enough to have my half day session on “Scaling SQL...
2011-06-19
917 reads
Ice Cubes and Top SQL Rally Speakers
That title may evoke thoughts of inappropriate SQL Karaoke or perhaps not but It is so nice to know I’m...
2011-06-18
880 reads
SSAS Maestro - Redmond Recap
Well today was the last day for a while I would be greeted by this sign:
It was a pretty exciting...
2011-06-18
853 reads
Prevent SQL Logins from using SSMS … or any other app
In a continuation of my previous LOGON TRIGGER post.
A downside to SQL logins is that anyone with the username / password...
2011-06-18
2,145 reads
Altering Table structure - SSMS - Timeout Expired
Altering a table using SQL Server Management Studio ( SSMS ) can be done by right clicking on the table and by...
2011-06-17
386 reads
Itzik Ben-Gan is in town
Not that you would know it from the page below, but Itzik Ben-Gan is back in London to do a...
2011-06-17
1,291 reads
SSMS Add-in for Analysis Services
A nice new little add-in available for SSMS on Codeplex. It helps with repetitive tasks involved with SSAS such as processing and deployment. ...
2011-06-17
1,075 reads
An Update on My Dell E6500
I bought my E6500 almost three years ago, giving away what was a perfectly good Latitude to trade up to...
2011-06-17
571 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