Interview question - Is Clustered index on column with duplicate values possible?

Through this article, we are going to discuss three important interview questions of SQL which are given below:-

 1) Can we...

Hekaton Part 3: Table Creation and Parameters

Part of a Series on "Hekaton". Refer below for previous posts

Introduction to Hekaton - Part 1Creating a Hekaton Database - Part 2
Having...

How easy or difficult to write dynamic SQL ? TIP#110

This is one of the challenge for most of the developer to write dynamic SQL. Generally we follow the approach...

Columnstore Indexes – part 62 (“Row Groups Trimming”)

Continuation from the previous 61 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have spoken a lot of times...

oPASS & MagicPASS Meeting Tonight

David Pless is presenting:
Query Store is a new feature in SQL Server 2016, and is also available in Azure SQL...

Here’s the New #Excel 2016 Chart Types!

The Office 2016 Public Preview is now available for download! Included in the preview of Excel 2016 are a handful...

Hadoop and Microsoft

In my Introduction to Hadoop I talked about the basics of Hadoop.  In this post, I wanted to cover some of...

Please Welcome Our New Certified SQL Server DBA’s!

Today we celebrated the last session of one of our Become a SQL Server DBA classes. This course takes people...

Open SQL Server Virtualization Q&A Webinar – 8/19

Next Wednesday, August 19th, at noon Eastern the PASSVirtualization Virtual Chapter will be holding an open questions and answers session...

Why I still like Excel PowerPivot models in SharePoint however Tabular solutions in SSAS are better

[2015-Aug-12] It’s quite obvious that in present time there is a growing audience for all the latest changes and updates...