Interactive Sorting Using a Tablix in Reporting Services
Many organizations collect data, lots and lots of data. We have the opportunity and ability today to collect more data...
2010-02-18
1,067 reads
Blog Posts
May I help you?
With the Vancouver games underway, I have been reflecting on the 2002 Winter Olympic Games. Those were the greatest winter...
2010-02-18
825 reads
More on SQLSaturday – From Jack Corbett
My friend Jack posted a nice aggregate of comments so far about the transfer of SQLSaturday to PASS, and added...
2010-02-18
550 reads
NOT EXISTS vs NOT IN
Continuing with the mini-series on query operators, I want to have a look at NOT EXISTS and NOT IN.
Just one...
2010-02-18
56,306 reads
Sometimes, you have to fix it yourself
The Problem
SQL Server is a huge product with lots of moving parts. Bugs happen. Microsoft has a place to voice...
2010-02-18
2,018 reads
SQLSaturday Acquired by PASS – Reactions
The Announcement
On February 2nd, PASS (@sqlpass), here, and Andy Warren (@sqlandy), here, announced ownership of the SQLSaturday franchise brand was transferred...
2010-02-18
1,238 reads
sys.dm_os_wait_stats
This is a short note explaining he sys.dm_os_wait_stats DMV.
This DMV returns the following columns/values regarding waits encountered by executed...
2010-02-18
1,322 reads
The Adversity Index
Found The Adversity Index while browsing and thought I’d share. It’s interesting to see the economic trends and I’ll let...
2010-02-18
501 reads
?? ??? ?????????? ?????? ?????? ????? ??? ?
????? ???????, ??? ?????? ???? ?????? ??????????? ??????, ????? ??? ???? ???? ?????? ????? ???? ????? ???? ?????? ????? ?????????....
2010-02-17
344 reads
2010 MVP Summit Held This Week
If you can’t tell what is happening in the above photo, you won’t be alone. Today, at the opening keynote...
2010-02-17
606 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...
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...
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 Kantor BCA KCU BANDUNG Telp/Wa 0817839777
Hubungi Cs: 0817844112 Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat...
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...
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