Windows 8 demo
A Windows 8 demo was just released. Looks really cool. Check it out at Previewing ‘Windows 8’ as well as Microsoft’s...
2011-06-02
676 reads
Un-SQL Friday #004: Speaker Lessons Learned
I began writing a story about, shall we say, a less than positive speaking experience…and then I realized: This is...
2011-06-02
1,100 reads
NEW: Microsoft SQL Server 2008 R2 Administration Cookbook
I have had the pleasure of knowing and communicating with Mr. Satya Shyam K. Jayanty, aka Satya/aka SQLMaster|twitterfor several years...
2011-06-02
2,245 reads
Just Deserts
Here’s another photo from my phone, this one from SQLSaturday Tampa in the cafeteria area. An easy typo to make,...
2011-06-02
609 reads
Duplicate Identity Values?
Can you have duplicate values in a field with the identity property? Of course, and this does it.
DROP TABLE dbo.MyTable
CREATE...
2011-06-02
4,274 reads
PASS 2011 Pre-Conference Seminars and Spotlight Sessions Released
I have wanted to go to PASS Summit for the last several years, but have yet to get an opportunity...
2011-06-02
680 reads
Do You Ever Physically Defragment Your SQL Server MDF & LDF Files?
Every since the first file was written to a floppy disk drive using DOS, physical file fragmentation has been a...
2011-06-01
1,997 reads
DQ & MDM Book Available to Download
If you’re looking for a resource on the Data Quality and Master Data Management features in SQL Server 2008 R2,...
2011-06-01
1,230 reads
PerformancePoint wish list – change a datasource
One item on my PerformancePoint wish list is the ability to change a datasource for an Analytic Chart/Grid. There is...
2011-06-01
822 reads
PASS Announces Pre-conference and Spotlight Sessions for PASS 2011 Summit
Today, PASS announced the Pre-conference and Spotlight Sessions for the PASS Summit 2011 in Seattle, which will run from October...
2011-06-01
1,109 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