Everything Is Awesome
If you don’t have kids you might not get the title of the post, it’s part of the theme song...
2014-02-17
635 reads
Last Weeks Top “Reading” Links #71
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-02-20 (first published: 2014-02-17)
1,819 reads
Home Workspace: Standing Desk
Ever since I worked in an office with adjustable standing desks, I’ve been thinking about getting a standing desk for...
2014-02-17
490 reads
Presenting at the kickoff Lynchburg Va SQL User Group meeting
There’s a new SQL Server user group starting up over in Lynchburg, VA. It’s first meeting is February 27, 2014...
2014-02-17
729 reads
Choosing the Right Analysis Services: MOLAP vs. Tabular Recording and Q&A
I hope you were able to attend my free webinar on Choosing the Right Analysis Services: MOLAP vs. Tabular on...
2014-02-17
1,748 reads
DBA Myths: An index on a bit column will never be used.
Not true. (Or I guess probably wouldn’t be posting about it would I?)
Probably the first thing I should point out...
2014-02-19 (first published: 2014-02-17)
2,628 reads
The RedMonk Programming Language Rankings: January 2014 #programming
The RedMonk Programming Language Rankings: January 2014
As long as we have been doing our programming language rankings here at RedMonk,...
2014-02-17
899 reads
Transact-SQL query to obtain basic information about partitioned tables
Here is the simple query that returns basic information about all tables in a database that are partitioned:
SELECT SCHEMA_NAME([schema_id]) AS...
2014-02-17
1,588 reads
Get performance statistics for queries and query plans that are cached by SQL Server for faster query execution
You can use the following two DMVs to give you that information:
sys.dm_exec_cached_plans – You can use this dynamic management view to...
2014-02-17
1,064 reads
First Presentation Ever And My 50th Post
Last Monday was the first time I've ever presented anything. Honestly, it was the first time really speaking in public...
2014-02-17
663 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