Stranger Danger… The need for trust with constraints

I ran into an issue with errors with an database upgrade running into a violation of a foreign key constraint....

Getting Started With Power BI Desktop: Installation

Power BI is becoming popular for a lot of reasons. Simply put, Power BI is “BI on your fingertips.” Companies looking to...

Quick Script: Index Sizes

In the world of performance monitoring, there a number of ways to identify problems. Each method is different and usually, neither...

Reblog: Slow source? Make your data flow buffers smaller!

Whoa whoah. Aren’t you supposed to increase your data flow buffer size in order to speed up your packages? If...

Getting and storing a high precision datetime

Earlier today I was working on a project where I was recording some time stamps. In order to get as...

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 create clustered index on a column containing duplicate values?

 2) Can we create...

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...