Read My Article "Here"
Ganapathi varmaSenior SQL Engineer, MCP
For more updates:
Subscribe for Blog posts [Click Here]
Follow FB Page [Click Here]
Follow FB Group [Click Here]
For...
2016-01-12
122 reads
It’s the second Tuesday of the month and you know what that means! T-SQL Tuesday time! If you don’t know...
2016-01-20 (first published: 2016-01-12)
1,389 reads
The use of SQL Audit can be viable to track the changes that may be occurring within your SQL Server - from a settings point of view
Related Posts:
CRM Data...
2016-01-12
10 reads
The second Tuesday of January 2016 is now upon us and you know what that means. Well, I hope you...
2016-01-21 (first published: 2016-01-12)
1,426 reads
Windows PowerShell is all about exploring .NET framework capability through the command line.Announced in 2006 it’s an admins paradise with...
2016-01-20 (first published: 2016-01-12)
2,558 reads
I continue to work on solving the Advent of Code puzzles in both PowerShell and T-SQL after completing them in...
2016-01-12
734 reads
After a very long waiting period, I have finally released the initial version of my Columnstore Maintenance solution for SQL...
2016-01-11
408 reads
While I never really enjoy a cross country flight back home my feet are very happy that I am finally...
2016-01-11
335 reads
[read this post on Mr. Fox SQL blog] Over the years I have presented many times to various clients describing Business Intelligence (BI) solutions using the Microsoft BI solutions stack. In all of...
2016-01-11
23 reads
[read this post on Mr. Fox SQL blog]
Over the years I have presented many times to various clients describing Business Intelligence (BI) solutions...
2016-01-19 (first published: 2016-01-11)
2,780 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