Three Engine Improvements in SQL Server 2008 R2 (Updated)
The upcoming release (by May 2010) of SQL Server 2008 R2 has been primarily focused on enhancements in the BI...
2010-02-02
441 reads
Three Engine Improvements in SQL Server 2008 R2
The upcoming (by May 2010) of SQL Server 2008 R2 has been primarily focused on enhancements in the BI area...
2010-02-02
958 reads
Reflections on ‘Visibility, the Art of Being Noticed’ by Phil Factor
If you have not read the Master of Phrenetic Phoughts’ article, please do so here. I enjoyed very much the...
2010-02-02
970 reads
Key Discovery III
Recursively traverse system views to build a Hierarchical Perspective into the database.
Related Posts:
T-SQL Tuesday Participation Over the Years December 19, 2018
T-SQL Tuesday #104: Just Can't Cut That Cord...
2010-02-02
25 reads
Key Discovery III
In Part I and Part II of the series, I discussed documenting and discovering Primary Keys and Clustered Indexes. In...
2010-02-02
1,730 reads
Providing Online Help for Powershell Modules
As a finishing touch for the SQL Server Powershell Extensions 2.0 Release I wanted to provide an online version of...
2010-02-02
2,008 reads
Identities and Transactions
I talked a little recently in a blog about gaps in identity values. They can occur when you delete rows,...
2010-02-01
597 reads
Some BI Related Official Microsoft SQL Server Blogs
My other Microsoft blog list was more focused on relational database administration and development, so here is my list of...
2010-02-01
759 reads
Some BI Related Official Microsoft Related SQL Server Blogs
My other Microsoft blog list was more focused on relational database administration and development, so here is my list of...
2010-02-01
298 reads
SQL Saturday #34 Wrap-up
Whew!
It’s over. New England Data Camp v2, aka, SQL Saturday #34, was completed on Saturday. Going in we had maxed...
2010-02-01
590 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