Sometimes a change is as good as a break : T-SQL Tuesday #134
James McGillivray (blog|twitter) wants us to give him a break. Well. Actually I guess he wants to know how we ... Continue reading
2021-01-12
141 reads
Blog Posts
TSQL Tuesday #134 – Taking a break
This month’s TSQL Tuesday invite is from James McGillivray – he asks people to write about what they were/are doing to take a break during this crisis ridden time...
2021-01-12
17 reads
Career Goals for 2021
I’m a couple weeks late, but not nearly as late as 2020. In any case, I’m going to break these down as I did last year, but hopefully with...
2021-01-11
23 reads
Daily Coping 11 Jan 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-01-11
16 reads
Identify the (Top 20) most expensive queries across your SQL Server using Query Store
Script to identify the most expensive queries on your database server using the Query Store DMVs. This allows you to look at data from a specific time frame, as...
2021-01-11 (first published: 2021-01-04)
695 reads
SQL Homework – January 2020 – Create an End of Year/New Year checklist.
It’s a brand new year and hopefully it will be better than last year. While that may be particularly true ... Continue reading
2021-01-11 (first published: 2021-01-05)
362 reads
Annual Corporate Report Filing for SQLOrlando
As a Florida corporation we have to file an annual report. Sounds complicated, but for us it’s a five minute task. Here’s the Trello card for the work I...
2021-01-10
4 reads
Annual Corporate Report Filing for SQLOrlando
As a Florida corporation we have to file an annual report. Sounds complicated, but for us it’s a five minute task. Here’s the Trello card for the work I...
2021-01-10
24 reads
Filing the Annual Tax Return for SQLOrlando
Similar to my earlier post on filing the annual report, once a year we have to file a tax return with the IRS. Basically if the revenue is less...
2021-01-10
16 reads
Filing the Annual Tax Return for SQLOrlando
Similar to my earlier post on filing the annual report, once a year we have to file a tax return with the IRS. Basically if the revenue is less...
2021-01-10
28 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