Azure First
Microsoft has been pretty clear about their commitment to the entire Azure infrastructure. The updates to Azure come out on...
2013-06-20 (first published: 2013-06-17)
2,260 reads
Last Weeks Top “Reading” Links #37
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-06-17
620 reads
Natural Born Killers (The series) – Day 1 Statistics
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-20 (first published: 2013-06-17)
3,412 reads
SQL in the City Goes Mobile
This week is the kickoff of the third year of SQL in the City from Red Gate. As we have...
2013-06-17
964 reads
Natural Born Killers (The series)
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-17
710 reads
Pivoting weird data in SSIS – Sort of…
Sometimes we get data in some bad forms. For example look at the below table:
The names and the amounts are...
2013-06-18 (first published: 2013-06-17)
2,081 reads
ORDER BY the numbers
Have you ever needed to order by a calculated column? You might have written it something like this:
SELECT LoginID, YEAR(HireDate)...
2013-06-19 (first published: 2013-06-17)
2,788 reads
Sql Server 2014…….What!!!
Yes, its true. Microsoft vice president has announce that new version of sql server 2014, will release on 2014… do...
2013-06-17
1,076 reads
PASS Data Architecture VC presents Steve Simon–Challenges Designing Finance Data Warehouse
Steve Simon will join us on Thursday June 20th at noon central to help us understand some challenges with designing...
2013-06-16
575 reads
Tracing Introduction
SQL Server tracing is essential for troubleshooting performance issues, yet it can put loads on your server that would cause...
2013-06-16
1,080 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