Which database is using all my CPU #2
A few weeks back we wrote about a query to tell you which database is using up most CPU time....
2011-07-12
1,494 reads
Teaching Transact-SQL at University of Denver, University College
Starting this week on Wednesday night, I will be teaching a special five-week condensed version of ICT 4462, Transact-SQL Programming...
2011-07-12
626 reads
Select random records using TABLESAMPLE clause
While I was reading Martin Catherall’s post about Selecting from a table with no rows returned I remembered TABLESAMPLE function...
2011-07-11
1,394 reads
5 Ways to Be a More Effective DBA Today
Regular readers will now that I like to talk (quite a lot) about how we can be more effective as...
2011-07-11
1,453 reads
2011 SQL Rally Evaluations - Reporting Services Boot Camp
I wrote this early in June, but lost it in my blog pile again and just found it…
First and foremost,...
2011-07-11
424 reads
SQL Server Myth on Clustered Index page allocation or B-Tree formation
Here is another SQL Server myth which I realised while understanding anatomy of index pages.
For a long time I...
2011-07-11
2,371 reads
How to move the Master database
The catch to moving the Master database is that you must also move the Resource database. Microsoft states that the...
2011-07-11
1,392 reads
Foreign Key Hierarchy Update
Today I would like to revisit a post of mine that is rather old. More precisely, the script in that post needs revisiting. This is one of my more...
2011-07-11
9 reads
Foreign Key Hierarchy Update
Today I would like to revisit a post of mine that is rather old. More precisely, the script in that...
2011-07-11
1,066 reads
Meme Monday – Horoscope
Did you know that your sign may have changed? I didn’t – at least not until reading the meme Monday announcement. Most people probably will see no difference in...
2011-07-11
9 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