2016-10-18
26 reads
Speaking on Consolidated Essential Performance Health Check using PowerShell – SQLSaturday (Portland)
Prakash will walk you through a centralized process using PowerShell where the key information collected, organized and sent via HTML formatted email, provides consolidated view of SQL server along...
2016-10-18
25 reads
Speaking on Consolidated Essential Performance Health Check using PowerShell – SQLSaturday (Portland)
Prakash will walk you through a centralized process using PowerShell where the key information collected, organized and sent via HTML...
2016-10-18
585 reads
October 2016 SQL Mastery Sessions
Everyone is really excited about PASS Summit being right around the corner and as usually happens, the folks at the Portland Oregon user group are putting on a SQL...
2016-10-18
6 reads
October 2016 SQL Mastery Sessions
Everyone is really excited about PASS Summit being right around the corner and as usually happens, the folks at the Portland Oregon user group are putting on a SQL...
2016-10-18
12 reads
October 2016 SQL Mastery Sessions
Everyone is really excited about PASS Summit being right around the corner and as usually happens, the folks at the...
2016-10-18
399 reads
Easy SQL Maintenance with Minionware
Here's my personal tweaked settings for deploying Minionware's fantastic Reindex & Backup jobs. In the development environment, I wanted to have...
2016-10-18
233 reads
DB CI: Getting Test Results in VSTS
One of the things I struggled with a bit was getting test results to appear in VSTS from my builds....
2016-10-31 (first published: 2016-10-18)
1,001 reads
Columnstore Indexes in 2 minutes
The standard way of storing relational database tables on physical media is row based, that is, each row occupies a contiguous space. The term that is used for this...
2016-10-18
17 reads
Columnstore Indexes in 2 minutes
The standard way of storing relational database tables on physical media is row based, that is, each row occupies a...
2016-10-18
221 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