Performance Impacts of Partitioned Aligned Indexes
[read this post on Mr. Fox SQL blog]
Continuing on with my Partitioning post series, this is part 2.
The partitioning includes several major...
2015-05-12
701 reads
T-SQL Tuesday #66 – Monitoring SQL Server
This is a T-SQL Tuesday that not only makes me smile, but makes my boss happy. In fact, I’m sure...
2015-05-12
819 reads
T-SQL Tuesday #66 – Monitoring
Thank you Cathrine Wilhelmsen for hosting this week’s #tsql2sday.
If I knew that this T-SQL Tuesday was going to be about...
2015-05-12
542 reads
Putting Your Head in the Clouds 3 – Cloud Service Offerings
By David Postlethwaite
Cloud Service Models
There are three main service models in the cloud. You will see these buzz words being...
2015-05-12
658 reads
Delivering a precon on Columnstore Indexes at SQLSaturday Cambridge
I am extremely happy to share that I shall be delivering a workshop at the amazing SQLSaturday Cambridge on 10th...
2015-05-12
491 reads
Taking (and passing!) the 70-461 Exam and Pursuing My MCSE Certification
Last week, I took the 70-461: Querying Microsoft SQL Server 2012 exam. I decided recently to try and achieve getting...
2015-05-12
803 reads
TSQL2sday #66 – Monitoring
A big thank you to Cathrine Wilhelmsen (blog | twitter) for hosting this month’s TSQL2sday party. Monitoring is this month’s topic...
2015-05-12
580 reads
T-SQL Tuesday 66 Monitoring – Agent Alerts
Alerts have been around for as long as I can remember, so some time before breakfast. That probably means you...
2015-05-12
1,159 reads
Make Sure You’re Eligible to Vote in the 2015 PASS Election.
Per the post from Bill Graziano, if you want to vote in the 2015 election you have to make sure...
2015-05-11
309 reads
The Murder Train is pulling into Iowa City
You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...
2015-05-11
574 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