Using Bookmarks to navigate code in SSMS (Day 24)
Bookmarks are used in SSMS to have SSMS remember selected line positions, and to quickly move between the bookmarks. All...
2018-01-24
353 reads
A Discussion of SQL Server-Related Topics
Using Bookmarks to navigate code in SSMS (Day 24)
Bookmarks are used in SSMS to have SSMS remember selected line positions, and to quickly move between the bookmarks. All...
2018-01-24
1,397 reads
Quick Editing Tips (Day 23)
There are many editing items in SSMS that makes formatting and navigating your code easier than ever. Most of these...
2018-01-23
317 reads
Quick Editing Tips (Day 23)
There are many editing items in SSMS that makes formatting and navigating your code easier than ever. Most of these...
2018-01-23
187 reads
Outlining (Day 22)
SSMS supports Outlining, the ability to selective hide blocks of code. This can be very useful, especially when working with...
2018-01-22
356 reads
Outlining (Day 22)
SSMS supports Outlining, the ability to selective hide blocks of code. This can be very useful, especially when working with...
2018-01-22
135 reads
Object Explorer Details (Day 21)
The Object Explorer Details windows (from the View menu, or the keyboard shortcut F7) displays detail information about the objects...
2018-01-21
377 reads
Object Explorer Details (Day 21)
The Object Explorer Details windows (from the View menu, or the keyboard shortcut F7) displays detail information about the objects...
2018-01-21
121 reads
Object Explorer Filtering (Day 20)
If you have a database with hundreds (or thousands) of objects, finding the one that you are looking for in...
2018-01-20
416 reads
Object Explorer Filtering (Day 20)
If you have a database with hundreds (or thousands) of objects, finding the one that you are looking for in...
2018-01-20
136 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