Sorting in Stored Procedures – Food for Thought
We know that sorting can be one of the most expensive things in an execution plan as shown below. However, we continue to do ORDER BYs repeatedly. Yes, I...
2020-01-29
50 reads
Blog Posts
What is a strong password anyway?
Background Fellow Microsoft MVP Troy Hunt (blog | Twitter) has been operating the website Have I Been Pwned (HIBP) for a number of years now. For the record, “pwned” is...
2020-01-29
188 reads
Coping with Self Doubt
One of the best coping mechanisms for Impostor Syndrome is the use of learned behaviors. This article shares some of these coping mechanisms and learned behaviors.
Related Posts:
Passion, Challenges, and...
2020-01-28 (first published: 2020-01-14)
641 reads
Extended Events Misperceptions: Profiler is Easier
I know, I know, I’m on #teamexevents so I think that Extended Events can do no wrong, but let’s address this thought that Profiler is easier. Now, if we’re...
2020-01-28 (first published: 2020-01-20)
533 reads
How to Resolve Remove-AzKeyVaultKey : Operation returned an invalid status code ‘Forbidden’ Error
I’ve come across another error message in my seemingly never-ending battle with Azure Key Vault. A while back I couldn’t delete a resource group because of Key Vault soft-delete....
2020-01-28
17 reads
How to Resolve Remove-AzKeyVaultKey : Operation returned an invalid status code ‘Forbidden’ Error
I’ve come across another error message in my seemingly never-ending battle with Azure Key Vault. A while back I couldn’t delete a resource group because of Key Vault soft-delete....
2020-01-28
2,821 reads
How to Resolve Remove-AzKeyVaultKey : Operation returned an invalid status code ‘Forbidden’ Error
I’ve come across another error message in my seemingly never-ending battle with Azure Key Vault. A while back I couldn’t delete a resource group because of Key Vault soft-delete....
2020-01-28
89 reads
How to Resolve Remove-AzKeyVaultKey : Operation returned an invalid status code ‘Forbidden’ Error
I’ve come across another error message in my seemingly never-ending battle with Azure Key Vault. A while back I couldn’t delete a resource group because of Key Vault soft-delete....
2020-01-28
8 reads
Trace Query in Extended Events
The ability to quickly and easily trace a query is important to database professionals. This script provides one useful alternative to trace a specific spid similar to the method...
2020-01-28
123 reads
Trace Query in Extended Events
The ability to quickly and easily trace a query is important to database professionals. This script provides one useful alternative to trace a specific spid similar to the method...
2020-01-28
7 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