Get each table space and their rows count
Sometime we need to know how much table space are used to store the data and also wish to know...
2016-04-11
172 reads
Generate list of all Month name
DECLARE @year INT
SET @year = 2016
;WITH months AS(
SELECT 1 AS Mnth, DATENAME(MONTH, CAST(@year*100+1 AS VARCHAR) + '01') AS monthname
UNION ALL
...
2016-04-11
224 reads
What is code coverage for?
Code coverage gives you an indication of how well tested a particular area is. It is not a measure of...
2016-04-11
447 reads
What is code coverage for?
Code coverage gives you an indication of how well tested a particular area is. It is not a measure of...
2016-04-11
45 reads
What is code coverage for?
Code coverage gives you an indication of how well tested a particular area is. It is not a measure of...
2016-04-11
52 reads
What is code coverage for?
Code coverage gives you an indication of how well tested a particular area is. It is not a measure of code quality and having a statement covered by a...
2016-04-11
8 reads
Unix Basic Commands
In similar context to my previous blog I'm providing a list of UNIX basic commands which you may find handy...
2016-04-11
662 reads
Cloud backup - MS StorSimple Applicance
In the previous post, I talked about how we can revamp the backup infrastructure for SQL to backup directly to Azure,...
2016-04-15 (first published: 2016-04-11)
2,208 reads
Starting with MS SQL Server
In one of my previous blog (https://sqldose.wordpress.com/2015/10/20/a-basic-introduction-of-database-tables-and-sql/ ) I gave a basic introduction about what is A Database and what is SQL. Now let us start with basic of...
2016-04-10
51 reads
Starting with MS SQL Server
In one of my previous blog (https://sqldose.wordpress.com/2015/10/20/a-basic-introduction-of-database-tables-and-sql/ ) I gave a basic introduction about what is A Database and what is...
2016-04-10
583 reads
Blogs
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
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