Columnstore Indexes – part 83 (“Columnstore Replication in SQL Server 2016”)
Continuation from the previous 82 parts, the whole series can be found at http://www.nikoport.com/columnstore/
A lot of things were changed in...
2016-05-29
1,007 reads
Why use a Date Dimension Table in a Data Warehouse
In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you...
2016-06-06 (first published: 2016-05-29)
7,162 reads
Restore a SQL Server Database with Different Methods
Database backups are generated as part of the business continuity planning procedure. Disasters with server or its database are a...
2016-06-02 (first published: 2016-05-28)
4,112 reads
Where are SQL Server 2016 Client Tools?
So, you just installed SQL Server 2016 and you’re pretty sure you chose the options to install the client tools...
2016-05-27
4,877 reads
My 24 Hours of PASS Session Files
I was honored to be selected to join many other great speakers in presenting for the recent 24 Hours of...
2016-05-27
996 reads
Why I'm not attending PASS Summit 2016
I know there has been a lot of drama in the community recently, much of it centered around what people...
2016-05-27
1,106 reads
Just a week to SQL Saturday in Pensacola
Next week is SQL Saturday #491 in Pensacola. I’ll be there, along with a number of other great speakers. It’s...
2016-05-26
799 reads
CPU Scheduling Basics – Windows and SQL Server
In this post we’re going to introduce the basics of CPU scheduling.
In a computer system, only one thing can happen at a time. More specifically, only one task can...
2016-05-26
22 reads
CPU Scheduling Basics – Windows and SQL Server
In this post we’re going to introduce the basics of CPU scheduling.
In a computer system, only one thing can happen...
2016-05-26
1,401 reads
SQL Server – Rollback transaction completely in case of error
Hi friends, I recently found an issue while inserting data into table during transactions that transaction will not completely rollback...
2016-05-26
670 reads
Blogs
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, which is...
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