The COUNT function in T-SQL
The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it...
2016-06-11
647 reads
The COUNT function in T-SQL
The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it...
2016-06-11
408 reads
Not More Than 16 Characters?!?
Microsoft, you’re killing me. This is the warning I received when typing in a password for Office 365:
I blinked when...
2016-06-16 (first published: 2016-06-10)
4,090 reads
How To Get A Free SQL Server Indexing Book – Week 2
Free Book! Another free indexing books, more awesome! In last week’s post, I talked about how I’ve got a number of copies of Expert Performance Indexing for SQL Server;...
2016-06-10
10 reads
How To Get A Free SQL Server Indexing Book – Week 2
Free Book!
Another free indexing books, more awesome!
In last week’s post, I talked about how I’ve got a number of copies...
2016-06-10
943 reads
Database Scoped Configurations
In SQL Server 2016, one of the key management improvement is a new feature that is called Database Scoped Configurations.
This...
2016-06-10
2,081 reads
SQL Server 2016 NYC Launch Event - Slide Decks Posted!
Quick post-event follow-up of our very successful SQL Server 2016 NYC Launch Event! We would like to thank ALL our...
2016-06-10
1,422 reads
MS Exams Increasing In Price
Just glanced through the MCP newsletter and see that the price of the exams (or at least the one I...
2016-06-14 (first published: 2016-06-09)
2,655 reads
PowerShell – Disk Space Monitoring and Early Warning Reports
Disk space is one of those things that frequently runs out of space no matter how much you bump it...
2016-06-09
1,342 reads
Protecting Against Delete without Where
If I’m doing any manual work with T-SQL, I always begin every set of data change operations with BEGIN TRAN...
2016-06-13 (first published: 2016-06-09)
3,644 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