Controlling what appears in the status bar and query tabs (Day 32)
When you run a query in SSMS, you are probably aware that the status bar contains many pieces of information...
2018-02-01
538 reads
A Discussion of SQL Server-Related Topics
SSMS Activity Monitor (Day 31)
SSMS provides an Activity Monitor, a process that displays various information about what all is going on with the instance....
2018-01-31
796 reads
Reports in SSMS (Day 30)
SSMS has a lot of reports available for you to use. Most of the reports in SSMS are off of...
2018-01-30
536 reads
Presenting with SSMS (Day 29)
If you are presenting with SSMS, then there are some extra steps that you need to take. These steps are...
2018-01-29
855 reads
Saving SSMS Settings (Day 28)
Over the last several weeks, we have been making several changes to various settings in SSMS. Now that you have...
2018-01-28
395 reads
Comparing Query Plans (Day 27)
When you are performance tuning code, you will frequently examine the execution plans to see what is happening. As you...
2018-01-27
458 reads
A month of SSMS tips and tricks
Wayne’s Tips and Tricks for SSMS
SQL Server Management Studio (SSMS ) is a program that many just launch daily (or only...
2018-01-26
700 reads
Working with Comments (Day 26)
We all know that we should liberally document our code with comments, so that others (and even yourself) will know...
2018-01-26
388 reads
Using the SSMS Web Browser (Day 25)
One of the things that I do with my code is to include reference links to what I was doing...
2018-01-25
356 reads
Using the SSMS Web Browser (Day 25)
One of the things that I do with my code is to include reference links to what I was doing...
2018-01-25
310 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...
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...
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