Mastering Index – Index on Computed Columns
This
article is the part of series Mastering Index, in this particular article
we will be exploring Index on computed
columns. Take a look...
2016-11-07
571 reads
Copying your SQL Database
If you have created a SQL Database in Azure (PaaS) and need to make a copy of it on the...
2016-11-07
409 reads
Knowledge vs Ability
Knowledge and ability, they are very inter-related. We born with only survival ability, ability to eat and drink, that’s pretty...
2016-11-07
1,405 reads
Building Open Source PowerShell
Open Source PowerShell is available on several operating systems, that really what’s special about the whole project! To get PowerShell to function on these various systems we need to...
2016-11-07
12 reads
Building Open Source PowerShell
Open Source PowerShell is available on several operating systems, that really what’s special about the whole project! To get PowerShell...
2016-11-07
675 reads
A New Beginning #SQLFamily
For the years I have been watching the SQLPASS session recording and hearing that it's really a different experience to...
2016-11-06
487 reads
Query Store - Part 3 - How it works?
Query Store collects 2 important kinds of data. They are
1) Compile time statistics - Query Plan, Estimated Costs, Estimated number of...
2016-11-06
822 reads
ETL Atomicity
I still remember the first real ETL process I developed. I was working for a hospital at the time, going...
2016-11-04
755 reads
Looking Back–Game Night at the 2016 #sqlsummit
I’m trying to look back at some of the events of the recent Summit, and Game Night was one of...
2016-11-04
555 reads
Webinar on Change Tracking for Data Warehouse Loads
Join me online on Tuesday, November 15th at 1:00PM as I host a webinar entitled “Managing Data Warehouse Incremental Loads...
2016-11-04
426 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