Come Speak at SQLSaturday Orlando on October 10, 2015
It’s five months until SQLSaturday Orlando, have you thought about your speaking plans for October? We’d love to have you come...
2015-05-11
357 reads
Monday Morning SQL Break – May 11, 2015
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2015-05-11
731 reads
Notes From SQLSaturday Jacksonville #391
Beautiful weather for a SQLSaturday! Everything went well, as expected but always appreciated. Just a few notes on this one:
They...
2015-05-11
282 reads
Watch The EngineerGuy–Great for Kids
Great explanation of some interesting engineering topics at http://www.engineerguy.com/.
2015-05-11
315 reads
Is Performance Better With LEFT JOIN or RIGHT JOIN?
I tend to write my queries using LEFT JOIN. Why? Because logically I see it in my head like this:
Give...
2015-05-20 (first published: 2015-05-11)
7,096 reads
Introduction to Azure DocumentDB
This is a basic introductory post about Microsoft’s new product: Azure DocumentDB, and how it compares to SQL Server.
What is...
2015-05-11
1,293 reads
Database snapshot captures only data changes or it will also save real database from DDL changes ?
Question : Database snapshot captures only data changes or it will also save real database from DDL changes (like table structure,...
2015-05-19 (first published: 2015-05-11)
5,626 reads
Fresh New Horror: PK on a Float Data Type
Here's a new thing to be scared about in the night, as if you weren't already terrified of floats after...
2015-05-18 (first published: 2015-05-11)
680 reads
SQL Server 2016 Announced, and it stretches to the Cloud!
Last week during Ignite, Microsoft CEO Satya Nadella announced the next version(Till then it was called as SQL vNext) of...
2015-05-10
1,018 reads
Editing Table Rows in SQL
When you create a database driven website, you actually write SQL scripts to insert data into the database. You also...
2015-05-10
751 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