9 Amazing features of SQL SERVER 2016
Although, I know I am bit late to share this thing on our blog but it says in Indian proverb...
2016-10-11
712 reads
T-SQL Tuesday #83: Why Leave Well Enough Alone?
It’s 2016. So why are we still dealing with T-SQL code and design patterns that were designed 7 versions ago?
In the 15 years I have been using databases professionally, we’re still...
2016-10-11
12 reads
Implementing Fuzzy Sets in SQL Server, Part 4: From Fuzzy Unions to Fuzzy Logic
By Steve Bolton
…………Fuzzy set relations carry an added layer of complexity not seen in ordinary “crisp” sets, due to the...
2016-10-10
812 reads
SSC Editorial: Does Log Data Belong in a Table or a File?
I think the topic of whether log data belongs in a table or a file would be a great one for...
2016-10-10
397 reads
Migrating Database Collation - The Red Gate Way
I had some cross database comparisons that I wanted to simplify, but ensuring the collation matched. The amount of objects...
2016-10-10
114 reads
SSC Editorial: A Visit to Microsoft
A Visit to Microsoft was posted back in August and I just re-read it. Here’s a quote that might interest you:
As...
2016-10-10
395 reads
Statistics Are Vital For Query Performance
This is post #10 supporting Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.
When you send a query to your...
2016-10-19 (first published: 2016-10-10)
2,091 reads
Columnstore Indexes – part 87 (“Indexed Views”)
Continuation from the previous 86 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
A very long time desired feature from...
2016-10-10
508 reads
Special Discount for PASS Summit Precon
I’m very honored to be speaking at the PASS Global Summitagain this year in Seattle during the week of October...
2016-10-14 (first published: 2016-10-10)
759 reads
Monday Night Networking at Summit 2016
It’s PASS Summit time and that means Andy Warren and I are doing another Monday Night Networking Dinner.
For those of...
2016-10-10
549 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