As we know, this Windows policy Lock Pages in Memory option determines which accounts can use a process to keep data in physical memory, preventing the Windows operating system from paging...
2015-01-20
14 reads
As we know, this Windows policy Lock Pages in Memory option determines which accounts can use a process to keep data in...
2015-01-20
1,989 reads
I have recently seen some “bad plans” being generated by the optimiser and from investigation, the cause came down to...
2015-01-20
1,739 reads
Over this past weekend, SQL MVP Kalen Delaney sent an inspiring note to the MVP email thread, and I wanted to...
2015-01-20
1,973 reads
I used to spend the 4th of July weekend (or week) in Austin with some buddy’s when we were in...
2015-01-20
928 reads
I was going to call this an upgraded HDD, but that’s not right. Technically it’s a drive update, but really...
2015-01-19
2,070 reads
T-SQL Tuesday has come and gone and I missed the boat due to some ongoing work constraints. With that said...
2015-01-19
565 reads
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-01-19
887 reads
There’s an old joke that goes, “Doctor, doctor, it hurts when I do this.” While the person in question swings...
2015-01-19
777 reads
EXCEPT and INTERSECT are two uncommon commands. Not that they do anything odd but they aren’t exactly well known in...
2015-01-23 (first published: 2015-01-19)
8,660 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