Columnstore Indexes: Finally Awesome in SQL 2016
Columnstore indexes are amazing for optimizing the performance of large rowcount queries that would otherwise look like a SCAN operation in...
2016-04-21
669 reads
Broken Left Join
Here is a simple example of a LEFT JOIN that returns the sales stats for all employees under 21.
SELECT e.Name,...
2016-04-21
579 reads
Promotions and Conflicts of Interest
I noticed my co-worker, friend, and PASS board member, Grant Fritchey, posted a note on members of the PASS Board...
2016-04-21
559 reads
Microsoft’s Commitment to Azure
For several years, many of us who were involved with working in Azure from the early days, were concerned that...
2016-04-21
534 reads
Loading Data into Clustered Columnstore Index with SSIS
I’m using a clustered columnstore index (CCI) on one of my fact tables at a client. The row size is...
2016-04-21
1,846 reads
Speaking at 24 Hours of PASS – The Evolution of Data Platform
As announced a couple of hours ago, a new edition of the famous online webinars 24 Hours of PASS will...
2016-04-21
359 reads
JSON in SQL Server 2016 – The Good, The Bad, and The Ugly
Microsoft introduced support for JSON data in SQL Server 2016 and in Azure SQL Database. I was excited to see...
2016-04-20
724 reads
A Speaking Sabbatical
Lately I’ve been thinking about taking a break from doing presentations. Not sure what triggered it – maybe just a sense...
2016-04-20
628 reads
Payment and the Board
If you read the March PASS Board meeting minutes, you saw that there was a discussion around board members and...
2016-04-20
501 reads
MongoDB – Insert,Update,Upsert and Delete Examples – CRUD
In MongoDB we have to use either insert() or save() method to add the document to a collection
Insert Single document
> db.employee.insert(
{"employee_id":1101,
"name":"Prashanth",
"sal":90000,
"dob": newDate(1983,2,3,5,20),
"department":
[
'DB Amdin','DB Developer'
],
"Location":"New York"});
Insert Multiple...
2016-04-20
740 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