Insufficient Disk Space (T-SQL Tuesday #88)
This month’s T-SQL Tuesday – hosted by Kennie T Pontoppidan(@KennieNP) – is called “The daily (database-related) WTF“. He asked us to be...
2017-03-27 (first published: 2017-03-14)
2,784 reads
Meagan Longoria
- Website: http://DataSavvy.me
Copying data from On Prem SQL to ADLS with ADF and Biml – Part 2
I showed in my previous post how we generated the datasets for our Azure Data Factory pipelines. In this post, I’ll...
2017-03-21 (first published: 2017-03-10)
1,737 reads
Copying data from On Prem SQL to ADLS with ADF and Biml – Part 1
Apologies for the overly acronym-laden title as I was trying to keep it concise but descriptive. And we all know...
2017-03-03
622 reads
Please Lend Me Your Vote for Documentation of TMSCHEMA DMVs
I spent a good bit of time looking for the definitions/descriptions of the TMSCHEMA DMVs that allow us to view...
2016-11-07
766 reads
Process Compatibility Level 1200 SSAS Tabular Model from SSIS 2014
A client wanted to upgrade their SSAS model to SSAS 2016 to take advantage of some of the features of...
2016-10-21 (first published: 2016-10-14)
4,889 reads
Documenting your Tabular or Power BI Model
If you were used to documenting your SSAS model using the MDSchema rowsets, you might have noticed that some of them...
2016-10-05
1,384 reads
BYO Time Zone Conversion With SSAS DMVs
This is just a quick note (since I apparently forgot and was puzzled for a moment) that the MDSCHEMA_CUBES DMV...
2016-09-21
486 reads
DAX Date Dimension and Fun with Date Math
I was working on a SSAS Tabular 2016 solution for a project for which I had no data (an empty...
2016-09-03
649 reads
Create a Date Dimension in Azure SQL Data Warehouse
Most data warehouses and data marts require a date dimension or calendar table. Those of us that have been building...
2016-08-11 (first published: 2016-08-06)
2,452 reads
PolyBase Is A Picky Eater – Remove Carriage Returns Before Ingesting Text
Update: As Gerhard points out in the comments, switching to ORC files solves this issue nicely. It’s not human readable,...
2016-08-09 (first published: 2016-08-01)
2,144 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