Which product was purchased the most? T-SQL
Suppose you had a list of product sales and were curious about which one was sold the most? It’s a...
2012-04-02
9,420 reads
Blog Posts
Why you *can't* provide your Facebook credentials
I know this isn't related to SQL Server, but it is related to security and privacy.
If an employer or...
2012-04-02
2,398 reads
Announcing SQLSaturday #175–In Flight Edition
One of the things I like about SQLSaturday is that it’s a place to try new ideas. This year on...
2012-04-01
693 reads
April Question: What’s your favorite DBA book, and why?
Over and over again, I get asked which DBA books I recommend. With this in mind, this month’s qustion is...
2012-04-01
1,117 reads
Install SQL Server 2012 Book online on local disk
After installing the SQL Server 2012 on my laptop, I found there is only online document available, no local book...
2012-04-01
26,006 reads
Slides & Samples for my DevWeek and SQLbits sessions
As I have announced in my DevWeek and SQLbits sessions, you can find my session materials
(slides & samples) here for download:...
2012-04-01
829 reads
SQL 2012 has Launched
LAUNCH
If you have been hiding under a rock, you have probably not heard that SQL 2012 has launched. With it,...
2012-04-01
992 reads
SQL 2012 has Launched
LAUNCH If you have been hiding under a rock, you have probably not heard that SQL 2012 has launched. With it, some really cool features are now available to...
2012-04-01
6 reads
Monitor SQL Server Backup job duration
if you run BACKUP DATABASE T-SQL, there is a parameter STATS which reports the percentage complete, However when you run the...
2012-03-31
1,924 reads
Presenting at SQLSaturday #107 in Houston in April 2012
I was just looking at the schedule for Houston, an amazing 10 tracks for this event on April 21, 2012....
2012-03-31
1,526 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