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
675 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
586 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
561 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
537 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,855 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
365 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
730 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
632 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
506 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
742 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
Question of the Day
Adding Bits I
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers