Don't exaggerate the difficulties of the RDBMS
Phil Factor argues that in learning about relational databases such as SQL Server, we should encourage people to "break a few pots".
2015-04-13
158 reads
Editorials
Pre-built or Ad Hoc
Steve Jones talks about the ad hoc nature of some NoSQL databases and whether that's something that most users want.
2015-04-13
154 reads
Kanban
Steve Jones talks about organizing and tracking work with kanban and how that might help you.
2015-04-07
329 reads
The Devil's in the Details
This week Steve Jones notes that the little details can sometimes have a big impact in your code.
2015-04-06
151 reads
Your Cloud Held Hostage – Could It Happen?
Today's guest editorial by Andy Warren is more of a movie plot than reality, but perhaps it's worth considering.
2015-04-06
139 reads
Large Chunks of Data
This Friday Steve Jones talks reporting. Specifically he wonders how long can a report be before it's just wasting space.
2015-04-03 (first published: 2010-09-17)
365 reads
2015-04-01
319 reads
Source Code Security
The code you use may contain security information. Be extra careful in this case, especially when you use encryption.
2015-03-31
160 reads
One Rule, Umpteen Constraints
Despite being deprecated for many years, Phil Factor explains why RULEs are still hanging on in there in SQL Server 2014.
2015-03-30
108 reads
Efficiency
This Friday Steve Jones asks about how you are tackling your career growth as you get older. Are you getting more efficient?
2015-03-26 (first published: 2010-10-22)
315 reads
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
The Goldilocks problem – Materialized Views
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
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