Shrinking Database Log Files
When should you shrink your log files and what does it mean to performance?
2016-02-15
137 reads
Shrinking Database Log Files
Files in SQL Server need to grow as the database grows, and in very specific circumstances need to be shrunk...
2016-02-15
1,291 reads
SQL Saturday 496 Exeter – PreCon Agenda
Hi
Unfortunately due to matters outside of my control, SQL Saturday 502 in Edinburgh has been cancelled, I would like...
2016-02-14
512 reads
PASS Summit 2016 Program Committee
As I usually do, I applied to be a member of the Program Committee for the 2016 PASS Summit. I have been on the program Committee the last 4...
2016-02-13
22 reads
PASS Summit 2016 Program Committee
As I usually do, I applied to be a member of the Program Committee for the 2016 PASS Summit. I...
2016-02-13
378 reads
Goodness-of-Fit Testing with SQL Server Part 5: The Chi-Squared Test
By Steve Bolton
…………As I’ve cautioned before, I’m writing this series of amateur self-tutorials in order to learn how to use...
2016-02-13
1,299 reads
Speaker of the Month: February 2016
I’ve been a little remiss on this. I just haven’t been getting out to see people speak for a while...
2016-02-12
460 reads
Reblog: SSIS Performance Testing
I had to do some performance testing for an MSSQLTips article and I thought I’d share the framework I used in...
2016-02-19 (first published: 2016-02-12)
1,742 reads
Limitation of In-Memory OLTP in SQL Server 2016 – Merge not supported with memory tables as target
Hi friends, in this post we will discussed another limitation of In-Memory OLTP that in-memory tables as a Target in...
2016-02-12
619 reads
SQL Family: The Wonder Years
Last week, Bill Wolf aka @SQLWareWolf and I somehow got onto the topic of High School pictures. So in jest, I...
2016-02-11
266 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