Columnstore Indexes – part 92 (“Lobs”)
Continuation from the previous 91 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Since the very first version of the...
2016-11-27
609 reads
Why Do People Think Dynamic Data Masking is a Good Idea? - SQL SERVER 2016 #5
Data security is always one of the important points which can not be ignored. Nowadays if you are working for...
2016-11-27
929 reads
Data Channel - Launch
Dear All,
I am starting a YouTube channel for SQL Server and Microsoft Data Platform Technologies called "Data Channel". What this...
2016-11-26
420 reads
Change the Collation Setting for Clustered SQL Server 2014 Instance
One of our SQL Server 2014 clusters was installed and after the install, my client told me that we are...
2016-11-26
214 reads
Don't Count on Me
This post is in support of Tim Ford’s (blog|twitter) #iwanttohelp challenge. And also written because this has burned me twice in the past 3 months and by blogging about it,...
2016-11-26
15 reads
ETL #73–NULL or NOT NULL and SQL Interview Questions
Today is the day after Thanksgiving. There are many things to be thankful so I decided to write a short...
2016-11-25
658 reads
Quick PoSh Kills with Stop-DbaProcess
I’ve been trying to get used to using the dbatools cmdlets in PoSh. They help me learn some PowerShell, but...
2016-12-02 (first published: 2016-11-25)
1,539 reads
Friday Reading 2016-11-25
Friday again so before I spend a weekend watching sci-fi movies, I’ll be reading:-
Virtue in the Virtual
Tony Davies discusses containerisation...
2016-11-25
489 reads
sqlservr.exe
We all know what the sqlservr.exe and its importance, but have you noticed the size difference of the .exe when comparing...
2016-11-25
725 reads
XmlReader vs XmlDocument Performance
Recently I have been working on a project where I needed to parse XML files that were between 5mb and 20mb in size. Performance was critical for the project,...
2016-11-24
25 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