Idera SQL Tools – An evaluation
Idera SQL ToolBox
(http://www.idera.com/Products/SQL-toolbox/)
The datasheet for ToolBox – asks the question – Want an Easy way to save money? No manager is going...
2010-09-02
2,213 reads
Blog Posts
Interview with the Intrepid Buck Woody
This is the second in a series of interviews with speakers presenting at the SQLServerCentral.com track at SQL Server Connections...
2010-09-02
1,209 reads
Networking to Build Business Contacts
I’m borrowing the title for this post from the pre-conference seminarDon Gabor is doing at this PASS Summit this year....
2010-09-02
371 reads
PASS 2010 Elections Are Open
Voting began yesterday with ballots mailed to qualified members. More information can be found here, including contact info for Hannes...
2010-09-02
259 reads
Pirates of PASS: Curse of the Elections Process
Pirate Code: They're more like guidelines really...
The last few weeks we’ve watched the drama unfold in regards to the PASS...
2010-09-02
1,305 reads
Product Review: SnagIt 10
Screen captures have become part of our computer culture… “I’ll send you a screen
shot of the window so you can...
2010-09-02
500 reads
SQL Saturday Advice - PhotoJournalism
I try to carry a camera, and a video camera, most of the time when I’m traveling. I have a...
2010-09-02
372 reads
Thanks for supporting this blog and make it successful
Hi friends
Thank you very much for supporting this blog. It really give me lots of encouragement to share my knowledge...
2010-09-02
770 reads
Whats best SQL Server or Oracle ?
Im often asked the question – whats best SQL or Oracle ?
The Oracle guys will tell you that SQL Server does not...
2010-09-02
604 reads
A Stored Procedure to Move SSIS Packages Between Servers
This post provides the code for a stored procedure to move SSIS packages between SQL 2005 SSIS servers. Continue reading ?
The post A Stored Procedure to Move SSIS Packages...
2010-09-01
3 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...
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