2016-10-13
1,254 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
The Snippet Manager in SQL Prompt
I love SQL Prompt, since it makes T-SQL coding quicker and easier. One of the handiest things is the Snippet...
2016-10-12
720 reads
2016-10-12
1,212 reads
Developer Deployment Frustrations
SQL Server should work to make it easy for developers to work with it, and include versions like Express in their applications.
2016-10-11 (first published: 2010-09-08)
371 reads
The Free-Con Returns to Seattle
On Monday, October 24, 2016, there will be a Free-Con in Seattle for those that might not be attending a...
2016-10-11
439 reads
T-SQL Tuesday #83–The Same Old Issues
This month is an interesting T-SQL Tuesday topic, and it’s brought to us by Andy Mallon, with the topic of...
2016-10-11
610 reads
2016-10-11
1,385 reads
Monday Night Networking at Summit 2016
It’s PASS Summit time and that means Andy Warren and I are doing another Monday Night Networking Dinner.
For those of...
2016-10-10
547 reads
Back for a Day
I hope everyone is well in Florida, but the hurricane caused a postponement of SQL Saturday Orlando. Fortunately I caught...
2016-10-07
424 reads
DBA Support
This Friday Steve Jones talks about your support load. Let us know how many databases you support and what the load is like.
2016-10-07 (first published: 2012-10-26)
249 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