Continuation from the previous 89 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is focusing on a...
2016-11-20
611 reads
SQL Server 2016 SP1 added loads of cool new features and options. One of those is a change that expands...
2016-11-22 (first published: 2016-11-20)
1,765 reads
Recently, after an security fix GDR (https://support.microsoft.com/en-us/kb/3194716) on SQL Server 2016 RTM, SQL Service refused to start. Though, the patch...
2016-11-20
1,210 reads
Change is inevitable, it's natural. I would like to quote few lines from Shrimad Bhagavad Gita says Change is the...
2016-11-19
448 reads
Microsoft just announced Microsoft SQL Server 2016 Service Pack 1 (SP1)
Microsoft reference: [Click Here]
Ganapathi varma ChekuriLead SQL DBA, MCPLinkedin
2016-11-19
257 reads
Since the Reporting Services product team announced last year that it was their intention to provide an on premises deployment...
2016-11-24 (first published: 2016-11-19)
2,145 reads
Different people approach their career in different ways. My working assumption, all the time, is that I don’t know enough...
2016-11-18
443 reads
SQL Server change tracking is a lightweight and synchronous mechanism for detecting inserts, updates, and deletes in tracked tables. For...
2016-11-25 (first published: 2016-11-18)
1,478 reads
Steve Jones wrote a great article on using this automation here titled The Demo Setup-Attaching Databases with Powershell. I threw...
2016-11-18
1,098 reads
Another week almost over so in-between daydreaming about relaxing this weekend I’ll be reading…
https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released/
SQL Server 2016 SP1 has been released....
2016-11-18
429 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