Using sys.dm_exec_sql_text() to figure out blocking is sometimes flawed.
I frequently rely on joining sys.dm_exec_requests and sys.dm_exec_sql_text() to know what queries are running on a system and when I...
2014-01-29
1,265 reads
Master Data Services for the Beginner Part 04
Introduction
In yesterday’s discussion we looked at populating entities and their related attributes. In today’s discussion we shall be concentrating on...
2014-01-29
2,118 reads
SSIS #116–What is the variable value at runtime?
Using variables in SSIS packages can make your ETL process more dynamic and respond to different scenarios during runtime.
Not...
2014-01-29
9,315 reads
[SQL Snacks Video] Importance of COPY_ONLY Backups
There are many features/options we sometimes overlook and then wonder later what went wrong. The COPY_ONLY option with backups is...
2014-01-29
695 reads
SQL Server Data Compression
SQL Server Data Compression Overview
I have been reviewing the options for data compression in SQL Server and believe it can...
2014-01-29
1,296 reads
February – Colorado SQL Events
SQL Meetings are training events for SQL Server professionals and those wanting to learn about SQL Server. Please note that...
2014-01-28
461 reads
Just use Version Control
There are free systems out there. If you have no budget, and want to get started, download one of these:
Subversion:...
2014-02-05 (first published: 2014-01-28)
2,955 reads
SQL Server Data Tools (SSDT) – January 2014 update
The SSDT January 2014 release has been updated to support both SQL Server 2012 Parallel Data Warehouse Appliance Update 1...
2014-01-28
1,486 reads
Movie Adaptations of Books
I’ve never written a novel or a movie script, but I’ve sure consumed a lot of both and enjoy both....
2014-01-28
807 reads
Virtualization resource consumption counters lie to you
OK, so maybe they do not lie to you, but I got your attention. In virtualized environments, the performance statistics...
2014-02-06 (first published: 2014-01-28)
2,150 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