The Ten Thousand Year Clock
Ran across this in my reading about the Ten Thousand Year Clock, a project funded by Jeff Bezos. Awesome dream....
2011-09-21
714 reads
Blog Posts
What Should I Carry in My Laptop Bag
I have a tendency to carry more than I need, the equivalent of the Batman Utility Belt. I just went...
2011-09-21
856 reads
What Will Be The Shared Experience at Summit 2011?
Last year it was the Tina Turner impersonator. Was it last year or the year before where the servers spun...
2011-09-21
654 reads
Who says you cannot mix business with pleasure?
There is an advice out there that says never to mix business with pleasure. It is not true in all...
2011-09-21
2,012 reads
24 Hours of PASS: Answer questions…
I will try my best to answer some of the questions after the Standard Operating Procedure webcast for 24 Hours...
2011-09-20
1,196 reads
Analytic Functions – CUME_DIST / PERCENT_RANK
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.
Analytic Functions in SQL...
2011-09-20
5,455 reads
Auditing Users in a Failover Partner Database
Auditing Users in a Failover Partner Database
SQL Audit is Watching
I read a question on a discussion list today asking if...
2011-09-20
1,639 reads
How to monitor number of VLF’s in your database
A few weeks back we did a blog post about a file grow bug that has been fixed with SQL...
2011-09-20
1,638 reads
Microsoft Releases Two Cumulative Updates for SQL Server 2008
Sticking to their eight week release cycle, Microsoft has released two different Cumulative Updates (CU) for SQL Server 2008. The...
2011-09-20
1,798 reads
Migrating to SQL Server from another Database platform
Migrating to SQL Server from another Database platform has a number of considerations
1) Create an inventory of existing applications. Separate into...
2011-09-20
1,164 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