Simple Series : SSIS Conditional Split
Conditional Split is a very powerful component, enabling you to send records in different directions or exclude them from the downstream...
2010-03-25
1,126 reads
Blog Posts
SQL Server 2008 Activity Monitor
For those people who like to use the Activity Monitor in the SQL Server Management Studio GUI instead of, or...
2010-03-25
2,871 reads
What Sessions Do You Want for the PASS 2010 Summit?
Survey was announced in the Connector on Wednesday, reposting the link here. We need your thoughts on this!
http://www.zoomerang.com/Survey/WEB22ADZ7NCK9A
2010-03-25
671 reads
A Personal Story about Networking
This is not a technical or SQL Server post, but it does illustrate the power of networking.
We recently took my...
2010-03-24
512 reads
Adding a Column to Every Table
I am Script. I will update your database.
Despite the best laid plans, sometimes circumstances or project scope change and the...
2010-03-24
670 reads
Avoiding Plagiarism
Having gone to an academic magnet school, I have quite a few friends who are teaching at the university level...
2010-03-24
1,917 reads
Creating SQL Server 2008 Databases with T-SQL
Imagine you need to create a database on a customer’s machine, but you don’t know how they have their file...
2010-03-24
1,402 reads
Getting Stubborn Chief Executive Officers to Listen: Speak Their Language
After consecrating several posts on workplace bullying, and hearing our great Steve Jones rant about Toshiba’s lack of action regarding...
2010-03-24
1,965 reads
Meeting Offsite and a Little Vacation
I’m heading to our “publishing summit” today at one of the Cambridge University buildings. I’m a part of the group...
2010-03-24
784 reads
PASS Update #27
I’m just back from the March 2010 Board meeting and it went better than usual (for any meeting). Most of...
2010-03-24
594 reads
Blogs
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...
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
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