Celebration
Steve Jones reminisces a bit and comments on reaching one million members in the community.
Celebration
Steve Jones reminisces a bit and comments on reaching one million members in the community.
Creating Hierarchical Data Structure Mashups
You can use SQL to connect or "mash-up" hierarchical structures, joining them at or below the root to create larger queryable hierarchical structures.
Using CROSS JOIN queries to find records out of sequence
This topic is nothing new, but well worth revisiting for those who have not used CROSS JOINS. You may have faced a problem where you need to compare historical records for a particular set of records to ensure that records have been saved in the correct order.
Solving the “Running Totals” Problem in SQL Server 2005 with Partitioned Tables
Lynn Pettis gives us a look at a new way to solve a T-SQL problem.
The January 2009 Car Update
With the start of a new year, Steve Jones gets back to the car updates with a look at winter driving and changes in the car industry.
Viewing the Data Profiling Task Data - SQL School Video
It can be helpful in ETL operations to know what the distribution of your data is. Brian Knight shows how to use the Data Profiling task in this video.
Dynamically getting mail profile for sp_send_dbmail
I have found that I like to generate a script once and roll it out to multiple servers at the same time. SQL Server 2008 Management Studio makes that fairly easy by allowing one window to connect to multiple instances simultaneously
Earning Credit
The topic of plagiarism rears its head at SQLServerCentral and Steve Jones has some comments and an apology.
Earning Credit
The topic of plagiarism rears its head at SQLServerCentral and Steve Jones has some comments and an apology.
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