2015-02-12 (first published: 2010-03-12)
4,953 reads
Scripts
Calculate Length - Most Advanced UOC
This function is used to calculate the actual unit of conversion for length.
2015-02-06 (first published: 2014-12-15)
856 reads
2015-02-05 (first published: 2013-03-22)
4,493 reads
Users , Roles and Logins
Useful script in cases where auditors would like to know roles for each user in each database of an instance as well as the status of associated logins.
2015-02-03 (first published: 2015-01-25)
2,980 reads
Calculate Volume - Most Advanced UOC
This function is used to calculate the actual unit of conversion for volume.
2015-01-30 (first published: 2014-12-16)
835 reads
Copy Latest Backups from Backup Path
This script is useful to copying latest backup files from job Backup path during Instance/Database Migration
2015-01-29 (first published: 2014-12-15)
983 reads
Update Statistics for databases where you have access
Run this stored procudure to update statistics for those SQL Server databases where you have permission
2015-01-27 (first published: 2015-01-08)
1,261 reads
Script to remove Backup Files except Recent One for Same Day
This script is useful to remove SQL backup files except latest one for same day from Backup Path.
2015-01-26 (first published: 2014-12-12)
1,109 reads
Calculate Power - Most Advanced UOC
This function is used to calculate the actual unit of conversion for power.
2015-01-23 (first published: 2014-12-16)
861 reads
Calculate Time - Most Advanced UOC
This function is used to calculate the actual unit of conversion for time.
2015-01-19 (first published: 2014-12-15)
1,029 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...
ALAMAT KONTAK BCA KCU BANDUNG Telp:08218154393
WA:08218154393 Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261
ALAMAT KONTAK BCA KCP Batakan Telp,Cs:08218154393
WA:08218154393 Jalan Marsma R. Iswahyudi 05, Rukun Tetangga No.20, Sepinggan, Kecamatan Balikpapan Selatan, Kota...
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