Top 3 Questions Before Submitting to a SQL Saturday
Hello Dear Reader! We are coming up upon the 9th SQL Saturday for Orlando. Orlando is where SQL Saturday began, and the home to some pretty amazing speakers. We,...
2015-06-25
11 reads
Top 3 Questions Before Submitting to a SQL Saturday
Hello Dear Reader! We are coming up upon the 9th SQL Saturday for Orlando. Orlando is where SQL Saturday began,...
2015-06-25
861 reads
24 Hours of PASS: The Data Loading Performance Presentation – Slide Deck and Scripts
Thanks to everyone who attended my 24 Hours of PASS session, The Data Loading Performance Presentation.
It was a lot of...
2015-06-25
672 reads
ExpressProfiler: say "Hi!" to new developer!
I glad to introduce new member of Express Profiler team - Chris Moore!
He has many ideas and eager to implement them.
Welcome...
2015-06-25
549 reads
SQL Azure has T-SQL Jobs - Well Almost
SQL Azure has T-SQL Jobs - Well Almost
JUNE 25, 2015
IntroductionOne thing that has been lacking in Azure SQL Database is the ability to write database jobs in Transact-SQL. Recently,...
2015-06-25
22 reads
SQL Azure has T-SQL Jobs - Well Almost
SQL Azure has T-SQL Jobs - Well AlmostJUNE 25, 2015
Introduction
One thing that has been lacking in Azure SQL Database is the...
2015-07-01 (first published: 2015-06-25)
2,855 reads
SQL Server Infernals – Circle 2: Generalizers
Object-Oriented programming taught us that generalizing is a good thing and, whenever possible, we should do it. Complex class hierarchies...
2015-06-29 (first published: 2015-06-24)
990 reads
oPASS June 2015: Using BI Power tools to visualize your SQL Infrastructure with Rodney Landrum
The next oPASS meeting is tomorrow night (June 25, 2015):
DBAs do not always have time to work with some of...
2015-06-24
399 reads
Working at Microsoft – A Year in Reflection
Last year after starting my new job with Microsoft as a Senior Consultant I wrote an article about my interviewing...
2015-06-24
688 reads
Seeking Full Day Seminars For The Friday Before SQLSaturday Orlando 2015
We’re planning to run one or two (or maybe even three) seminars (aka pre-cons) in conjunction with SQLSaturday Orlando 2015....
2015-06-24
499 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