COLUMNSTORE INDEX… DEMO
COLUMNSTORE INDEX
How data is stored in traditional way
For physical storage of a table, its rows are divided into a...
2015-07-11
2,558 reads
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...
2015-07-11
838 reads
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...
2015-07-11
14 reads
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...
2015-07-11
1,483 reads
Script to find complete months between two given dates
Below script will help in finding the complete months within the 2 given dates. In the below script we takes below dates as exampleStartdate =2015-07-05Enddate =2016-01-06
/**********************Script Start**************************/IF (object_id('tempdb..#month') is...
2015-07-10
16 reads
Script to find complete months between two given dates
Below script will help in finding the complete months within the 2 given dates. In the below script we takes...
2015-07-10
829 reads
Script to find the complete weeks within two given dates
Sometimes we need to find out the complete weeks within two given dates. Below script will help in finding the complete weeks within 2 given dates. In this script,...
2015-07-10
22 reads
Script to find the complete weeks within two given dates
Sometimes we need to find out the complete weeks within two given dates. Below script will help in finding the...
2015-07-10
807 reads
Microsoft Azure Data Catalog
Just announced is the Microsoft Azure Data Catalog, which is an enterprise metadata catalog / portal for the self-service discovery of...
2015-07-10
1,029 reads
PASS Summit Precon – The Complete Primer to SQL Server Virtualization
I am very pleased to announce that Argenis Fernandez and I will be presenting a new precon training session at...
2015-07-10
553 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers