Control Flow Package Parts are a new feature in Microsoft SQL Server 2016 that attempts to enable code reuse within SQL Server Integration Services packages. The intent is great, but like...
2016-10-14
198 reads
Control Flow Package Parts are a new feature in Microsoft SQL Server 2016 that attempts to enable code reuse within SQL Server...
2016-10-20 (first published: 2016-10-14)
3,574 reads
As a SQL Server DBA or developer here is what you should know about memory-optimized tables (in-memory tables):
Introduced in SQL Server 2014
Primary store is main memory, second copy maintained on...
2016-10-13
13 reads
As a SQL Server DBA or developer here is what you should know about memory-optimizedtables (in-memory tables):
Introduced in SQL Server 2014Primary...
2016-10-13
305 reads
I had a new presentation to give this week at IT/DevConnections. This is a paid for conference, and I want...
2016-10-13
852 reads
Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work.
Different indexes work best...
2016-10-13
601 reads
A couple of years back I achieved the Microsoft certification MCSE – Business Intelligence. You can read all about that process in...
2016-10-13
790 reads
This week's Super duper IT training offers are in:
If you see any that take your fancy let me know. Drop...
2016-10-13
443 reads
Every now and again I would navigate to Microsoft’s certification page and see what / if any changes have taken place...
2016-10-13
538 reads
There are hundreds of blogs that compare the T-SQL ISNULL function with the ANSI standard COALESCE function. There are also...
2016-10-13
1,306 reads
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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