100th post
This is my 100th blog post here at LessthanDot!
(I’m not lying, check for yourself)
I started blogging at the end of...
2015-07-10
525 reads
Podcast about my career and the SQL Server Community with Chris Bell
During my time at SQL Saturday in Philadelphia (Early June), Chris Bell invited me to be a guest on his...
2015-07-09
691 reads
Why I won’t be running SQL Server Standard Edition on Business Critical Servers!
I keep getting questions around what core features are missing in Standard Edition of SQL Server,and why there is a...
2015-07-09
1,163 reads
Introduction To Dynamic Data Masking in SQL Server 2016
In release of SQL Server 2016 CTP 2.0 another new feature that is released is Dynamic Data Masking. Using Dynamic...
2015-07-09
614 reads
Overview of Published Articles – 2015Q2
Here is an overview of the articles I published in the secondt quarter of 2015.
INTENSE SCHOOL
Book Review: Query Tuning & Optimization by...
2015-07-09
532 reads
SQL Server Storage best practices
Server storage is one of the most important things for SQL Server performance. Chances to utilize a lot of RAM and...
2015-07-09
3,481 reads
Proper Aliasing will help you somewhere TIP#104
Recently, When we were delivering session on “SQL SERVER” one of the persons asked why we require Aliasing so I...
2015-07-09
468 reads
Layer a database into a SQL Server container
In my previous post on running SQL Server in a container I showed how you could use the Spoon (https://spoon.net)...
2015-07-08
1,342 reads
Layer a database into a SQL Server container
In my previous post on running SQL Server in a container I showed how you could use the Spoon (https://spoon.net)...
2015-07-08
42 reads
Layer a database into a SQL Server container
In my previous post on running SQL Server in a container I showed how you could use the Spoon (https://spoon.net)...
2015-07-08
41 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
Alamat BCA KCP ITC Roxi Mas Telp:08218520153
WhatsApp CS 628218520153 ITC ROXY MAS, Jl. Kh Hasyim Ashari No.125 Basement 13, RW.8,...
Alamat BCA KCP Sawah Besar Telp:08218520153
WhatsApp CS 628218520153 Jl. Sukarjo Wiryopranoto No.28 C, RT.1/RW.1, Kb. Klp., Kecamatan Gambir, Kota...
Alamat BCA KCP Pasar Tanah Abang Tlp:08218520153
WhatsApp CS 628218520153 Jl. KH Fachrudin 36 Blok D/23, Kp. Bali, Kecamatan Tanah Abang,...
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