SQL Server Management Data Warehouse (MDW) – Why it Rocks
Ensuring excellent performance for users and customers is a high priority for Database Administrators.
Today I want to share a free and easy...
2013-04-16
2,494 reads
John Sansom
SQL Server Management Data Warehouse (MDW) – Why it Rocks
Ensuring excellent performance for users and customers is a high priority for Database Administrators.
Here I share a free and easy way for you to get valuable insight into the...
2013-04-16
178 reads
Implicit Conversions and Avoiding Them With Computed Columns
I recently encountered an interesting performance issue (due to implicit conversions) that I was able to solve using a lesser known...
2013-04-02 (first published: 2013-03-25)
3,979 reads
Implicit Conversions and Avoiding Them With Computed Columns
I recently encountered an interesting performance issue (due to implicit conversions) that I was able to solve using a lesser known technique and I wanted to share it with...
2013-03-25
37 reads
How To Be An Expert At What You Do
Every successful company has them. They’re the lifeblood of their organisations. Linchpins essential to getting things done and doing them...
2013-03-20
1,050 reads
Career Growth and How You Can Achieve Explosive Results
Continued investment in your professional development for career growth is hard. It’s also essential to being a successful Data Professional.
You’ve...
2013-03-05
1,530 reads
Something for the Weekend – SQL Server Links 01/03/13
It’s SFTW Time, I hope you’ve had a great week!
Make sure you don’t miss this weekly round-up of SQL Server...
2013-03-01
1,079 reads
Restart the SQL Server Agent Service using PowerShell
Just a quick one today chaps, to show how you can restart the SQL Server Agent Service using PowerShell.
Whilst covering...
2013-02-26
5,098 reads
Multitasking A Ridiculous Workload – How I Do It
I don’t! There’s no such thing as multitasking. At least, not how most of us think about it……
Being successful as...
2013-02-19
967 reads
Overconfidence – How it Almost Cost Me and What You Can Do to Avoid It
It was early one morning and I was working on a production deployment to add a new Subscriber to an...
2013-02-15 (first published: 2013-02-05)
3,777 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