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
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...
2015-07-10
430 reads
Blogs
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...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers