What’s the difference between a temp table and a table variable?
I recently saw an answer to this question on dba.stackexchange.com written by Martin Smith. It was probably one of the...
2014-02-24
1,109 reads
Modern Retail Architectures Built with Hadoop | Hortonworks
We’ve probably all heard the famous quote by John Wanamaker, the father of modern advertising: “Half the money I spend...
2014-02-24
1,047 reads
HealthySQL 2.0 for SQLSaturday#268
Over the last year, I was presenting and touring the SQL Saturday circuit with my HealthySQL 2.0 presentation. HealthySQL is...
2014-02-24
1,197 reads
Challenges with Downgrading TFS 2010 from SQL Enterprise to SQL Standard Edition
I recently had the challenge of migrating an installation of Microsoft Team Foundation Server 2010 from a shared SQL Server...
2014-02-27 (first published: 2014-02-24)
2,907 reads
Standard Deviations with CTE in SQL
I was working with a client recently getting the number of standard deviations a student was off the average number...
2014-02-24
362 reads
Standard Deviations with CTE in SQL
I was working with a client recently getting the number of standard deviations a student was off the average number...
2014-02-27 (first published: 2014-02-24)
3,355 reads
R skills attract the highest salaries #r #getpaid4stats
Two recent salary surveys have shown that R language skills attract median salaries in excess of $110,000 in the United...
2014-02-24
1,297 reads
SQL Saturday OKC 309!
SQL Saturday OKC is coming up!
The event will be August 23rd, 2014!
Now is the time to get signed up. We...
2014-02-24
517 reads
Oracle Tips for MSBI Devs #5: Working with Oracle on Windows Azure
As you have likely noticed in my series, Oracle Tips for MSBI Devs, I have done a lot of work...
2014-02-24
893 reads
February '14 Acadiana SQL Server User Group
I am honored to be the very first presenter of the new PASS chapter in Lafayette, Louisiana this Tuesday, presenting...
2014-02-23
620 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