Useful reading this week
This is a short post for a Sunday afternoon, I thought I’d share some useful reading from the week gone...
2010-02-14
870 reads
Blog Posts
SQL Server 2005 & 2008 SP Release Dates
Microsoft has announced that Service Pack 2 for SQL Server 2008 will be released in the third quarter of 2010,...
2010-02-13
807 reads
SQL Server 2005/2008 Servicing Plans
Microsoft Group Program Manager Matthias Berndt has a post up on the Microsoft SQL Server Release Services blog (which is...
2010-02-13
594 reads
A Tale Of Two Execution Plans – Solved!
Earlier this week I wrote about a perplexing problem I was having where identical servers were producing different execution plans...
2010-02-12
1,311 reads
eReading – Lending Books
I sent this to Barnes and Noble, as well as Random House recently after the much vaunted “lending” technology in...
2010-02-12
723 reads
Farewell, Robert B. Parker
I heard the news via a blog post by Ward Pond that one of my favorite authors had died at...
2010-02-12
1,731 reads
Foundation Class Review
This week was an exciting teaching week for me. I taught the Pragmatic Works Foundation class, one of my favorite...
2010-02-12
663 reads
Free SQL Server Training Webinar Series
SQLServerCentral.com, PragmaticWorks, and Wrox Press are sponsoring a series of free SQL Server webinars in February. Called the SQL Server...
2010-02-12
883 reads
PASS is Seeking Program Committee Volunteers
The sessions presented at the PASS Community Summit are selected by volunteers from the PASS Program Committee. If you would...
2010-02-12
364 reads
Syndication Schedule Changes
We have a process that reads syndicated blogs from people and then publishes them here. It’s worked well, and allows...
2010-02-12
624 reads
Blogs
AI Helps Me with My Sloppiness
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
WITH clause gets a 26ai boost!
By way of background, a while back I did video called “My New Favourite...
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
How We Handled a Vendor Retry That Loaded Twice in Snowflake
Comments posted to this topic are about the item How We Handled a Vendor...
Cognitive Coverage
Comments posted to this topic are about the item Cognitive Coverage
Question of the Day
Getting the Average
I have this data in the dbo.Commission table in a SQL Server 2022 database.
salesperson commission Brian 12 Brian 16 Andy 7 Andy 14 Andy 21 Steve 20 Steve NULLAll the data is a varchar, and I decide to run this query to get the totals for each salesperson.
SELECT SalesPerson
, AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
FROM commission
GROUP BY SalesPerson
GO
What average commission is calculated for Steve? See possible answers