Get Free Learning
A couple of different events going on today and tomorrow:
Today (03/20) at 3pm CDT - "Choose Your Own Adventure: Performance Tuning"...
2012-03-20
486 reads
Blog Posts
Microsoft Releases SQL Server 2008 SP2 Cumulative Update 9
Right on schedule, Microsoft has released SQL Server 2008 SP2 Cumulative Update 9. This is Build 10.00.4330.00, and it has...
2012-03-20
1,809 reads
PASS for Today (and Tomorrow)
I just wanted to plug two events that are free SQL Server training. First, Thomas LaRock (@sqlrockstar) and Jason Strate...
2012-03-20
589 reads
Seldom Used Indexes
On occasion you may ask yourself if there are any under used indexes in your database. If not you, then possibly a manager or client. Usually this comes up...
2012-03-20
4 reads
SSIS: Script Component Asynchronous Transformation
The SSIS script component can be configured to use synchronous or asynchronous outputs. If the script component is configured for...
2012-03-20
8,156 reads
24-Hours of PASS - Be on-time!
Right on the heels of the recent SQL Server 2012 virtual online launch event (as in virtually not there :-), a...
2012-03-19
1,817 reads
Another Interesting Sort
In October of 2011, I shared an example of a peculiar set of sort requirements. Today, I am going to...
2012-03-19
845 reads
Another Interesting Sort
Some code requirements can be met through various means including the use of a different collation - which means a lot of testing.
Related Posts:
Creative Database Naming January 2, 2020...
2012-03-19
7 reads
Columnstore Indexs
Columnstore Indexes for Fast DW
The SQL Server 11.0 release (2012) introduces a new data warehouse query acceleration feature based on...
2012-03-19 (first published: 2012-03-15)
4,058 reads
Looking to Windows 9
I haven’t played with Windows 8 yet, and only a little with Windows Phone 7, but I am a little...
2012-03-19
1,400 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