How do you audit automatically generated sql deployment scripts?
I saw recently an email where someone stated that the reason that they manually create deployment scripts is that because...
2016-05-03
57 reads
How do you audit automatically generated sql deployment scripts?
I saw recently an email where someone stated that the reason that they manually create deployment scripts is that because of the restirctions put on them by the requirements...
2016-05-03
11 reads
Implicit Conversion and Performance
Letting SQL Server change data types automatically can seriously impact performance in a negative way. Because a calculation has to be run...
2016-05-03
620 reads
Weekly Round-up 30 April 2016
It’s been an interesting week for me. I spent last week in Toronto delivering a SQL Server upgrade course and...
2016-05-03
368 reads
SQL Server – Row Level security in SQL Server 2016 – Part 1
Hi friends, in SQL 2016 several new security features gets introduced which will help users to protect their data in...
2016-05-03
483 reads
Goodness-of-Fit Testing with SQL Server Part 7.3: The Anderson-Darling Test
By Steve Bolton
…………As mentioned in previous installments of this series of amateur self-tutorials, goodness-of-fit tests can be differentiated in many...
2016-05-02
1,387 reads
Monday Morning SQL Break – May 2, 2016
Gotta love Mondays. At least the weather here in Minnesota is clearing up, the last two weeks have been cold...
2016-05-02
468 reads
SQL Server 2016 available June 1st!
Woo hoo! Microsoft has announced that SQL Server 2016 will be generally available on June 1st. On that date all four...
2016-05-02
665 reads
PowerSehll : How to suppress the table heading and remove the blank space from a text file
There are a multiple ways to suppress and remove the first line from text file. The first scenario would be writing...
2016-05-02
7,830 reads
How to Convince the Boss to Send You to PASS Summit
August two years ago I originally posted, Make the PASS Summit Work for Your Employer. After conversations at several SQL...
2016-05-02
997 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