Yup, @StrateSQL’s Running for the PASS Board of Directors
Why I’m Running Over the past few years, I’ve been considering running for the PASS Board of Directors and this year appears to be the right year to do this....
2016-10-05
53 reads
Yup, @StrateSQL’s Running for the PASS Board of Directors
Why I’m Running
Over the past few years, I’ve been considering running for the PASS Board of Directors and this year appears...
2016-10-05
908 reads
Microsoft certification changes
A recent Microsoft blog post announced that they are releasing five new Microsoft Certified Solutions Expert (MCSE) and Developer (MCSD) specialties. ...
2016-10-05
784 reads
Where Do We Go To Share?
No one reads blogs any more.
Twitter is dying.
Facebook is broken.
LinkedIn? Please.
G+. Is that even on any more?
Where do we go...
2016-10-05
486 reads
Floor, Round, and Ceiling
I saw an interesting question today about rounding. Specifically they always wanted to round down. Now as it happens that...
2016-10-05
654 reads
Overview of Published Articles – 2016Q3
Here is an overview of the articles I published in the third quarter of 2016.
What’s New in SQL Server Integration Services...
2016-10-05
526 reads
Documenting your Tabular or Power BI Model
If you were used to documenting your SSAS model using the MDSchema rowsets, you might have noticed that some of them...
2016-10-05
1,409 reads
SQL Live Health Check - part 2 - historical data and configuation
In the previous post (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2016/09/30/say-hello-to-sql-live-health-check-part-1/) I talk about the main screen where you can have a single glance of the...
2016-10-05
1,340 reads
Understanding the new MAXDOP settings in SQL 2016
If you have just begun using SQL Server 2016 or you have been using it for a while now you...
2016-10-05
3,119 reads
Restore through FULL backup
Problem
A common misconception that i've heard a few times around backups is that a FULL backup invalidates previous TRANSACTION LOG...
2016-10-04
326 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