Getting the Most Out of SQL Server Profiler Using Templates
In case you haven’t discovered this for yourself, SQL Server Profiler is one of the most powerful tools that come...
2009-12-07
1,411 reads
Getting Things Done: The Zone
Cross-Posted from A Goal-Keeping DBA blog:
I'm reading Getting Things Done because of Brent Ozar's excellent blog post, How I Use...
2009-12-07
694 reads
Upcoming Speaking Engagements for December 2009
Next week, I have the honor of presenting two different sessions on SSIS. These 2 events are the last speaking...
2009-12-07
606 reads
Dismissing Warnings in SSAS 2008
When working with Analysis Services, you will often run into the same warnings over and over as you are developing....
2009-12-07
491 reads
Good Programmer = Lazy & Dumb?
Alternative title for programmers using C-derivatives and Java:
Good Programmer == Lazy & Dumb?
I read this blog post, Why Good Programmers Are...
2009-12-07
670 reads
64 Bit Virtual PC Substitute - OpenSource to the Rescue
Hey there gang. I, like many of you, am very excited about the new betas for the 2010 product stack...
2009-12-07
464 reads
Code Camp - Tampa, FL.
I recently attended Code Camp in Tampa and I want to thank everyone who made a SQL guy feel so...
2009-12-07
320 reads
Verizon Wireless and Data Integration FAIL
I recently was working with a client and as sometimes happens, I could not get on their network. Not a...
2009-12-07
511 reads
List of 50 Interesting Web Sites from Time Magazine
Ran across the Time Top 50 web site list and thought I’d share. I’m fond of lists, especially about web...
2009-12-07
425 reads
Fundamentals of Storage Systems – RAID, An Introduction
In previous articles, we have covered the system bus, host bus adapters, and disk drives. Now we will move up...
2009-12-07
8,957 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