SQLIntersection conference wrapup
Two weeks ago was a busy one. I helped coordinate and spoke at our second SQL Saturday Omaha on April...
2013-04-25
803 reads
5 SQL Server White Papers Every DBA Should Read
There are countless sources for information on SQL Server available today. There are books, webcasts, conferences, and blogs. With all...
2013-04-25
862 reads
Consultants – Why pay more?
As an independent consultant who has a higher bill rate than average, I would hope it is obvious to clients that the...
2013-04-25
1,422 reads
SQL Lunch – GeoFlow: 3D Geospatial Visualization
Join me next month to learn about a new Geospatial visualization feature of Excel 2013 on the SQL Lunch.
Lunch Details
#75-GeoFlow:...
2013-04-25
1,445 reads
Adding Data to Filestream with T-SQL
I’ve written on how to enable Filestream and how to add a filegroup, but I haven’t touched the Filestream impact...
2013-04-25
1,381 reads
Database Administration KPIs – 1/2
As a DBA, we may all have this question: How should my work be evaluated objectively? or in another way,...
2013-04-25
530 reads
Database Administration KPIs – 1/2
As a DBA, we may all have this question: How should my work be evaluated objectively? or in another way,...
2013-04-25
3,549 reads
How to backup a SQL 2012 database directly to Windows Azure
It has been a little while since I posted something and I’ve been meaning to finish off this blog for...
2013-04-24
1,934 reads
PowerSQL – Generate Only Index Script of All Tables or Specific Tables
Background of this implementation-As a part of Performance tuning, We noticed huge avg_disk_queue_length on F drive after analysis, we’ve recommended to...
2013-04-24
856 reads
Identify the cause of SQL Server blocking
In my previous article (Different techniques to identify blocking in SQL Server) on MSSQLTips.com, I discussed about locks and blocks,...
2013-04-24
907 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