COLUMNSTORE INDEX… DEMO

COLUMNSTORE INDEX
How data is stored in traditional way
For physical storage of a table, its rows are divided into a...

Columnstore Indexes – part 59 (“Aggregate Pushdown”)

Continuation from the previous 58 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
SQL Server 2016 brings a number of...

Do you know about Whatsapp web?

Whatsapp claims that they currently have 500 million users worldwide. That is pretty impressive looking at the good amount of...

Do you know about Whatsapp web?

Whatsapp claims that they currently have 500 million users worldwide. That is pretty impressive looking at the good amount of distinctively decent competitors they have within the space of...

Online Training event: Designing a Mobile Dashboard Solution with Microsoft DataZen

I’d like to make you aware of a three-hour training event that I will be presenting, hosted by SQL Server...

Online Training event: Designing a Mobile Dashboard Solution with Microsoft DataZen

I’d like to make you aware of a three-hour training event that I will be presenting, hosted by SQL Server...

011 – Get The Tools! - WaterOx Consulting

Reading Time: 1 minutesJust get the freakin’ tools already! In WOxPod!, episode # 011 –...
The post 011 – Get The Tools! appeared...

100th post

This is my 100th blog post here at LessthanDot!

(I’m not lying, check for yourself)

I started blogging at the end of...

Automatic database restore

Often times database administrators were asked to restore production database backup to UAT or development environment, sometimes it will needed...

But I Don’t Have a Test Server…

I frequently see statements on forums along the lines of “I don’t have a test server, so I’m going to...