Write The Perfect Question (Of The Day)
Have you ever voted against something only to be glad later you got out voted? Too many years ago the...
2014-03-05 (first published: 2014-02-25)
1,496 reads
Approachable? Sometimes.
Deservedly so, I got called out for a bit of attitude I displayed in a recent blog post: Time for...
2014-03-06 (first published: 2014-02-25)
1,851 reads
Reinstall SQL Server Performance Counters
I’ve had several instances over the last few months where I had to reinstall the SQL Server Performance Counters. It...
2014-03-04 (first published: 2014-02-25)
4,609 reads
How to Load Data from Excel in SSIS – 32-bit vs. 64-bit
Let's say you are developing an SSIS package on your dev box to load data from an Excel file to...
2014-02-25
3,665 reads
Spezialrabattaktionen: 22% zum Jubiläumsjahr der PASS Deutschland e.V für Sicherheits- XEvent Tracing, sowie SQL Server 2014 Seminare + 10% Microsoft TechNet Aktion für alle
Damit auch alle, die vor 2 Wochen nicht auf der SQL Konferenz in Darmstadt (www.sqlkonferenz.de) waren, oder nicht regelmäßig bei...
2014-02-25
754 reads
ERROR || The query processor is unable to produce a plan because the index ‘IND_TABLE’ on table or view ‘Table’ is disabled.
Table with clustered index is totally depended on index accessibility.
ERROR : The query processor is unable to produce a plan because...
2014-02-25
5,119 reads
Free Month To PluralSight!
Free Month of PluralSight!
Ok, personally this is pretty cool. www.SQLSkills.com is giving away a free month to pluralsight! Well, let...
2014-02-25
1,277 reads
How to Load Data from Excel in SSIS – 32-bit vs. 64-bit
Let’s say you are developing an SSIS package on your dev box to load data from an Excel file to...
2014-02-25
1,192 reads
Lock Escalations
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-03-03 (first published: 2014-02-25)
4,773 reads
Tonight: NYC Metro User Group Presents Kimberly L. Tripp & Jonathan Kehayias
Tonight: The NYC Metro User Group Presents Kimberly L. Tripp (blog) and Jonathan Kehayias (blog)!
Let's welcome them to NYC! Now at...
2014-02-25
1,217 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...
FARE LABS Pvt. Ltd. is a Proficiency testing laboratory located in India.
The top proficiency testing facility in India is Fare Labs. We employ particular metrics...
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
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