SQL Lunch Starting at 11:30 CST
If you are available for lunch today don’t forget to sign in and watch Thomas LeBlanc talk about Historical DMV...
2009-09-28
589 reads
Patrick LeBlanc
Trace Flag 1118
Yesterday morning around 6AM, my Blackberry started going off. The subject line of every email was, “SQL Timeouts”. In the...
2009-09-25
8,065 reads
Upcoming SQL Lunch – Historical DMV Information
Date: 9/28/2009
Time: 11:30 AM
Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=F7DRFD&role=attend
Presenter: Thomas LeBlanc. Thomas is a Database Administrator for Amedisys, Inc in Baton Rouge, LA....
2009-09-25
583 reads
SQL Lunch – Pick your favorite Logo
We have been working on the logo for a month now, but instead of making the final decision I have...
2009-09-23
780 reads
Windows Internal Database
This past Friday I received a call from our systems team stating that they were running low on Disk Space...
2009-09-22
4,608 reads
TSQLScripts.com – Script of the Week
After about 3 weeks of digging through .css files and html code I finally found the problem with the site. ...
2009-09-21
509 reads
Upcoming SQL Lunch (Live Meeting) – Historical DMV Information
The next SQL Lunch is scheduled for Monday, September 28. See below for details
Date: 9/28/2009
Time: 11:30 AM
Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=F7DRFD&role=attend
Presenter: Thomas...
2009-09-21
478 reads
SQL Server 2008 R2 August CTP – Utility Control Point (UTP)
I finally carved out some time in my day to try and get the August CTP of SQL Server 2008...
2009-09-18
1,362 reads
Article of the Week – Kevin Kline “Social Media Scene”
This weeks article is written by Kevin Kline, which is titled “Getting Up-to-Speed on the SQL Server Social Medial Scene”. ...
2009-09-16
934 reads
Today’s SQL Lunch - Oracle-CDC for SQL Server Integration Services
Join us today for a SQL Lunch
Date: 9/14/2009
Time: 11:30 AM
Reserve your seat:https://www1.gotomeeting.com/join/509742840
Presenter: Jeff Cole. Jeff has been designing and building...
2009-09-14
720 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