T-SQL Tuesday #080 – The Gift of the Basics
This month’s T-SQL Tuesday (#080) is being hosted by Chris Yates (B|T) (Happy B-day Chris!). He decided that this month’s...
2016-07-12
531 reads
SQL Server Error 3257 – Causes and Solution
Overview
While working with SQL server, users may encounters numerous errors in different stages. These errors creates huddles in SQL transactions...
2016-07-12
929 reads
Default database file sizes
It’s Chris Yates (b/t) birthday! (I think he just tured 19.) And in honor of his birthday we are writing...
2016-07-12
759 reads
T-SQL Tuesday #80–Chris Yates’ Birthday
It’s the 80th version of T-SQL Tuesday. You can see all the parties from the past on my page, but...
2016-07-12
504 reads
Target Recovery Interval and Indirect Checkpoint
Introduction The process that writes the dirty pages from the system memory (RAM) to the disk is called the checkpoint process. Dirty pages consist of the data and log...
2016-07-12
11 reads
Target Recovery Interval and Indirect Checkpoint
Introduction The process that writes the dirty pages from the system memory (RAM) to the disk is called the checkpoint process. Dirty pages consist of the data and log...
2016-07-12
55 reads
Target Recovery Interval and Indirect Checkpoint
Introduction
The process that writes the dirty pages from the system memory (RAM) to the disk is called the checkpoint process....
2016-07-12
299 reads
Target Recovery Interval and Indirect Checkpoint
IntroductionThe process that writes the dirty pages from the system memory (RAM) to the disk is called the checkpoint process....
2016-07-12
586 reads
Are you a new SQL Server DBA? Live Blog @LearningTree
This week I’m teaching Learning Tree’s course 2108 SQL Server Database Administration course in LEC in London. Following on from...
2016-07-12
561 reads
Training To-Do List for New DBA
Are you an entry-level DBA, or looking to make the career switch? Feel like you are looking up from the...
2016-07-18 (first published: 2016-07-12)
4,955 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...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
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