Dedicated Administrator Connection (DAC)

Learn how you can determine which connection is using the Dedicated Administrator Connection.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

2018-10-02

3,123 reads

Blogs

Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...

I type fairly well. Well, I type fast, but I do wear out a...

By way of background, a while back I did video called “My New Favourite...

Comments posted to this topic are about the item SQL Art, Part 4: Happy...

WA:0821-8154-398 Istana Regency Sudirman, Jl. Raya Cijerah Raya No.2 Ruko No 19 & 20,...

Comments posted to this topic are about the item How We Handled a Vendor...

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       NULL

All 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?