CISL – Columnstore Indexes Scripts Library, Release 1 (“Ortus”)
I am glad to announce the very first release of the CISL – Columnstore Indexes Scripts Library, with codename “Ortus”.
Go on...
2015-09-01
598 reads
I am glad to announce the very first release of the CISL – Columnstore Indexes Scripts Library, with codename “Ortus”.
Go on...
2015-09-01
598 reads
Continuation from the previous 62 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Data Loading is one of the most...
2015-08-19
796 reads
Continuation from the previous 61 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have spoken a lot of times...
2015-08-12
573 reads
This great book by Ricardo Semler is something that some of my friends have been recommending me to read for...
2015-08-04
426 reads
I guess in the age of rapid development and releases the fact of General Availability of the Power BI v...
2015-07-29
1,074 reads
Education. The key topics for everyone.
In his incredibly famous TED Talk “Do Schools Kill Creativity“, which might be some of...
2015-07-28
490 reads
Continuation from the previous 60 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
A lot of financial calculations in the...
2015-07-21
550 reads
There are a number of high quality events in Europe that are being run by the local volunteers or user...
2015-07-15
510 reads
Continuation from the previous 59 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is dedicated to some...
2015-07-14
659 reads
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
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Comments posted to this topic are about the item Let's Talk Certifications
Comments posted to this topic are about the item The Hidden Security Risks of...
Comments posted to this topic are about the item 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