An Informal Compendium of SSAS Errors, Part 3: Unresolved Errors
This is the second in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...
2011-10-02
1,822 reads
Blog Posts
Dataset with Text or Stored Procedure
As most of you already know, Reporting Services reports make use of Datasets to get data. These Datasets can get...
2011-10-02
1,242 reads
Slides & Samples from my SQLbits sessions
As
I have announced in all of my sessions at the SQLbits conferences in Liverpool/UK,
you can find here the
Slides & Samples for...
2011-10-02
923 reads
SQL Saturday 85 Follow Up
Last weekend I travelled down to SQL Saturday 85 in Orlando, FL. Like all of the other events that I’ve...
2011-10-02
989 reads
SQL Saturday 97 has ended
Well it isn’t quite over for me just yet, I still have a flight home tomorrow and can’t wait to...
2011-10-02
478 reads
24 HOP recordings
For all of you, that you have missed any session from the last 24 HOPass - you can check here
24 Session...
2011-10-01
1,165 reads
Come For The Education Stay For The Networking
OMG! SQLSATURDAY #97 IS HERE!
I am really excited about SQLSaturday #97! In just a few short hours we will be...
2011-10-01
749 reads
How to find out which Table is not having rows in SQL Server?
Introduction
Many times while tuning our production databases we might try to find out the list of tables not having even...
2011-10-01
2,331 reads
Live Blogging SQL Saturday #97 Austin (hashtag #sqlsat97)
Hello and welcome to my live blog/recap of SQL Saturday #97 in Austin! Wes Brown and the crew from CACTUSS...
2011-10-01
498 reads
October Question: What one thing do you feel has the greatest impact on SQL Server’s performance?
When it comes to databases, many DBAs obsess over performance, and for good reason, as when user’s begain to complain...
2011-10-01
1,094 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