Calling all London/Sussex Sql Developers does this sound like you? Would you like to set up Continuous Integration or Continuous Deployment Do you want to get your databases...
2015-03-19
19 reads
Calling all London/Sussex Sql Developers does this sound like you? Would you like to set up Continuous Integration or Continuous...
2015-03-19
50 reads
Calling all London/Sussex Sql Developers does this sound like you? Would you like to set up Continuous Integration or Continuous...
2015-03-19
45 reads
I have finally submitted a session for a speaking engagement. Those who know me know that this is a very...
2015-03-19
748 reads
Whenever a piece of software does something that makes me think this is awesome I find myself blocking out the...
2015-03-19
66 reads
I’ll be doing a precon for SQLSaturday #387 in Madison Wisconsin on April 10th, 2015 titled “Planning a High Availability and Disaster...
2015-03-19
1,197 reads
Microsoft Azure provides you two options when hosting your SQL Server-based data warehouse: Microsoft Azure SQL Database and SQL Server...
2015-03-30 (first published: 2015-03-19)
7,713 reads
I’m going to do a shorter editorial on this, but really I think this deserves more treatment here.
I saw Brent...
2015-03-27 (first published: 2015-03-19)
7,145 reads
Beginning in version 2005, SQL Server is making manipulation of partitioned set of rows easier by using Window Functions (ROW_NUMBER(), aggregate functions...
2015-03-26 (first published: 2015-03-19)
6,317 reads
SQL Server 2014 Deprecated Features – Database Engine
Everyone looks at the new features when trying to determine when to upgrade from...
2015-03-19
2,054 reads
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...
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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