Computing the Trimmed Mean in SQL

Author: sqlteam.com
Category: SQL Server
Comments (0)

This article presents code to compute a trimmed mean in SQL. The trimmed mean is a more robust version of the simple mean (SQL AVG() aggregate function). It is a useful tool for summarizing ill-behaved real world data.

Read More...

Read Next: SQL Server 2000 Gains on Oracle

Comments

Subscribe via RSS

Subscribe to GeekArticles.com by Email

Enter your email address:

Subscribe in a reader

SQL Server

Naming Database Objects: Part II

Trace Messages Part V: Trace Cleanup

Naming Database Objects: Part I

Multiple-Child Aggregation

Creating SQL Tables for an Integrating Application Using Dexterity

SQL Server 2005 Beta 2 Transact-SQL Enhancements

.NET Rocks! - Brian Larson on SQL Server Reporting Services

Computing the Trimmed Mean in SQL

SQL Server 2000 Gains on Oracle

Separator First Formatting (SFF)

SQL Server 2005 Webcasts

Reading a Trace File using C# in SQL Server 2005

PASS 2004 Presentation: Profiler and Trace in SQL Server 2005

Automatically Process SQL Server Trace Files

Microsoft SQL Server Health and History Tool

The Daily Database Build

Trace Messages Part IV: Getting the Trace Results

Trace Messages Part III: Session End an Metrics

Tip: Using sp_addextendedproperty in order to add a property that's longer than 255 characters.

Trace Messages Part II: Writing to the Trace

Computing the Trimmed Mean in SQL

Comments

Post Your Comment:

Subscribe via RSS

SQL Server

Sponsored Links