Performance Monitor Counters for SQL Server performance testing
I posted “Window Perfmon scripting, SQL Server perfmon and how to perfmon” which refers to a performance monitor counters.
The perfmon counters...
2011-09-23
3,437 reads
Blog Posts
PerformancePoint – Using SSAS Actions
The latest project I worked on had a heavy dose of PerformancePoint and one of the requirements was to launch...
2011-09-23
2,301 reads
Re-blog – September 16 – September 22
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-09-23
611 reads
SQL Saturday 89 has come and gone!
All the planning, stressing, and freaking out about SQL Saturday #89 came to and end this past weekend. We had...
2011-09-23
418 reads
SQLSaturday #85 is Tomorrow!
It’s 7am on Friday and I can’t wait for the day to end, head home to change and then go...
2011-09-23
608 reads
SQLSaturday Orlando Is Tomorrow!
Tomorrow marks the 4th annual SQLSaturday Orlando, held at Seminole State College in Sanford. We've got 46 sessions by 40+...
2011-09-23
872 reads
This field is missing from the returned result set from the data source.
This warning
The dataset ‘dataset1' contains a definition for the Field ‘column1'. This field is missing from the returned result set...
2011-09-23
8,394 reads
Using Unary Operators to control Analysis Services hierarchy aggregations
Analysis Services hierarchy aggregations can be easily controlled using unary operators. For example, in accounting there are GL accounts that...
2011-09-23
2,262 reads
Analytic Functions – PERCENTILE_CONT / PERCENTILE_DISC
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.
Analytic Functions in SQL...
2011-09-22
11,801 reads
Miss 24 Hours of PASS ? No problem, all videos are online
All the videos for the sessions at 24 Hours of PASS are available for free. Check the session schedule for...
2011-09-22
566 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