Training
I'm kind of stunned. I have asked 6 people to go to the PASS conference over the last 4 days...
2007-09-17
691 reads
I'm kind of stunned. I have asked 6 people to go to the PASS conference over the last 4 days...
2007-09-17
691 reads
One of the fundamental rules of a stable, controlled production system is that you apply updates singly, after they've been tested, and you document the change. This way you can ensure that if a problem occurs, you can do some backtracking to see what might have caused instability.
2007-09-17
1,213 reads
2007-09-16
2,183 reads
So I got a final count of referrals from the PASS conference yesterday and it was 183, so thanks to...
2007-09-14
658 reads
Editorial coming next week, but so far this is amazing to me. Microsoft's stealth updates of their client update tool....
2007-09-14
612 reads
2007-09-14
3,258 reads
I caught this quote from Microsoft Watch, and thought it was very interesting. It definitely addresses an issue I've wondered about for some time. It talks about the WGA server issues and had this great quote from the WGA Product Manager:
2007-09-14
114 reads
Do you like recruiters? Do you use them? It's almost impossible not to use them these days when looking for a job. So many of the listings on online job boards are from recruiters and many have deals to place people, so chances are you'll at least deal with on even if they don't get you a job.
2007-09-13
180 reads
With business intelligence and the Anaylsis Services platform becoming more and more popular, this has to be the hottest development team for SQL Server. Join us with a look at one of the leaders of Analysis Services development, Rob Zare.
2007-09-13
1,701 reads
OK, here's one take. Not sure if it's any good, but it's a start.
No live editorials yet. I've been working...
2007-09-13
659 reads
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item How We Handled a Vendor...
Comments posted to this topic are about the item Cognitive Coverage
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