Does The Order Of Index Columns Matter?
Watch this week's video on YouTube
When beginning to learn SQL, at some point you learn that indexes can be created to help improve the performance of queries.
Creating your first...
2018-09-04
14 reads
Blog Posts
Does The Order Of Index Columns Matter?
Watch this week's video on YouTube
When beginning to learn SQL, at some point you learn that indexes can be created to help improve the performance of queries.
Creating your first...
2018-09-04
6 reads
Don’t cutoff yourself with dates in T-SQL – Did you know…
Almost all the applications we use have a lot of options. And, sometimes we even stumble across them by accident.
Who’s...
2018-09-04
270 reads
Don't cutoff yourself with dates in T-SQL - Did you know...
Almost all the applications we use have a lot of options. And, sometimes we even stumble across them by accident. Who’s ever heard something like “Normal user don’t even...
2018-09-04
24 reads
Getting started with SQL Server Tools
This article is part of the SQL Server Tools series, aimed at giving you an idea of the available tools and techniques...
2018-09-04
652 reads
Interview Query – 1
Somewhere on internet i found this question. Thought to share it with you all. We have two tables, school_students and Class_student. ...
2018-09-04
47 reads
MongoDB 4.0.2 release
As i was discussing about MongoDB in my earlier blog, on NOSQL ACID stands for Atomic, Consistent, Isolation, and Durable...
2018-09-04
231 reads
Power BI Custom Visuals Class (Module 115 – Circle KPI Gauge)
In this module you will learn how to use the Circle KPI Gauge. The Circle KPI Gauge displays a single...
2018-09-04 (first published: 2018-08-14)
3,212 reads
T-SQL Tuesday #106 – Trigger Headaches or Happiness
Since I took over the T-SQL Tuesday a few months ago, I decided I ought to host again. Especially since...
2018-09-04
286 reads
Volunteer for the PASS NomCom
The call for applications for the Nominating Committee closes on Sep 10th. If you care about the future of PASS...
2018-09-04
273 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