Query multiple SQL Server instances at one time! Thanks for watching! Kevin3NF Follow @Dallas_DBAs
The post SQL Server Registered Servers appeared first on DallasDBAs.com.
2022-11-09 (first published: 2022-10-28)
468 reads
I was working on two publisher contracts at the same time. I highly recommend never doing that. One is done, though, and it’s officially published as of September 2022....
2022-10-27
84 reads
Why doesn’t SQL Server automatically check for the Group –> Object type when you are adding perms via SSMS? This hangs me up almost every time. I think “omg...
2022-10-27
31 reads
Today’s coping tip is to write down three specific things that have gone well recently. Easy, as a lot of things have gone well. I’m going with some travel...
2022-10-27
28 reads
Rarely do I say I love a feature across any technologies I have come across, in the snowflake world this is right up there. I tend to find this...
2022-10-27
99 reads
Kristyna and I were working through some updates to our site and realize that this was going to be our 250th blog post on Data on Wheels. I thought...
2022-10-26
33 reads
Today’s coping tip is to recognize that you have a choice in what to prioritize A good one for me, especially as I’m a little stressed and overloaded with...
2022-10-26
25 reads
Redgate started a new marketing thing and I like it. They’re asking for memories of attending the Summit in Seattle. I’ve been lucky enough to go to many of...
2022-11-07 (first published: 2022-10-25)
913 reads
Today’s coping tip is to share a helpful quote, picture, or video with a friend. I usually enjoy sharing quotes with friends on their birthdays. Those of you who...
2022-10-25
25 reads
Some people have shower thoughts, I have 1am thoughts. In this case it was the only keyword required in a ... Continue reading
2022-11-07 (first published: 2022-10-25)
690 reads
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Comments posted to this topic are about the item Split Large Queries in Athena...
Comments posted to this topic are about the item 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