When Should You Use Identity as a Clustered Index Key?

A few days ago, while delivering my session, The Data-Loading Performance Presentation, I was asked when, performance-wise, Identity should be...

Presentations & Blogging of 2015 in Review

Another year is coming to an end and I am doing a review of which goals I have managed to...

Top 10 Enhancements to Azure SQL Database in 2015

Top 10 Enhancements to Azure SQL Database in 2015
DECEMBER 27, 2015

Introduction2015 has been a massive year for Azure SQL Database. This year has seen the product mature from "an...

Top 10 Enhancements to Azure SQL Database in 2015

Top 10 Enhancements to Azure SQL Database in 2015DECEMBER 27, 2015
Introduction
2015 has been a massive year for Azure SQL Database....

Type 6 or Hybrid Type 2 Slowly Changing Dimension with Biml

In my previous post, I provided the design pattern and Biml for a pure Type 2 Slowly Changing Dimension (SCD). When...

Columnstore Indexes – part 75 (“Stretch DB & Columnstore”)

Continuation from the previous 74 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post focuses on one of...

Learn How to Insert Data From Stored Procedure Into Table?

Stored Procedures are considered most efficient way for calling and retrieving data and hence users always look forward to encapsulate...

Bad queries!!!

Once it happend quite a black Friday for my environment after a deployment. The application got sucked so that becoming worst and...

Columnstore Indexes – part 74 (“Row Group Merging & Cleanup, SQL Server 2016 edition”)

Continuation from the previous 73 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Row Group merging & cleanup is a very...

Giving Thanks Around the Holidays

In the West, the holiday season summons different memories and plans for different people. The thought of gorging on a...