T-SQL Tuesday #102–Getting Started
It’s time for another blog party, on the second Tuesday of the month. For this month’s T-SQL Tuesday, Riley Major...
2018-05-08
807 reads
Blog Posts
T-SQL Tuesday: Giving back to the community
This month’s T-SQL Tuesday from Riley Major (b|t) asks us to figure out a way to give back to the...
2018-05-08
414 reads
Automating Automatic Indexing in Azure SQL Database
I’ve been in love with the concept of a database as a service ever since I first laid eyes on...
2018-05-07 (first published: 2018-04-30)
1,957 reads
Day 7 Configuration – Environmental Variable
On day 6 we discussed about Programs. today is very important day, we will discussing about Configuration options or parameters. All...
2018-05-07
248 reads
Is It Possible To Conditionally Index JSON Data?
Check out this week’s episode on YouTube.
Recently I received a great question from an attendee to one of my sessions...
2018-05-07 (first published: 2018-05-01)
1,983 reads
Know About SQL Server Error 6401
Introduction
The ACID acronym standing for Atomicity, Consistency, Isolation, and Durability are the properties of SQL transactions. Transactions are used when the database has to be modified by using one...
2018-05-07
29 reads
Know About SQL Server Error 6401
Introduction
The ACID acronym standing for Atomicity, Consistency, Isolation, and Durability are the properties of SQL transactions. Transactions are used when...
2018-05-07
2,667 reads
Notes from SQLSaturday Jacksonville 2018
Notes:
Great attendance, easily 400+Lunch was smooth this year due to changing to boxed lunchesRooms were in 2 different buildings. Sometimes...
2018-05-07
291 reads
SQL Server Why Isn't My Transaction Log Truncating
The Transaction log growing is completely normal however there are situations where a transaction log can get to a state...
2018-05-07
72 reads
Which are the queries using a particular index or table?
The DMV sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats give you excellent detailed information about how the indexes are being used and what operations...
2018-05-07
1,103 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