SQLServerCentral.com Content tagged T-SQL, Aggregates

Aggregates in T-SQL

Fri, 21 Dec 2012 07:00:00 UT

Aggregates

Thu, 06 Dec 2012 07:00:00 UT

Generating SubTotals using GROUPING

Fri, 16 Nov 2012 07:00:00 UT

This article explains how to use the GROUPING clause to generate subtotals for rows in a very easy fashion.

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

SUM and Addition of Null

Mon, 05 Nov 2012 07:00:00 UT

Basic of T-SQL

Mon, 20 Aug 2012 06:00:00 UT

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Aggregate Function Product()

Mon, 06 Feb 2012 07:00:00 UT

The TSQL aggregate function SUM() gives a number based on the addition of the values of multiple rows to each other. Do the same thing but with multiplication instead of addition.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

How to get monthly YTD data

Tue, 24 Jan 2012 07:00:00 UT

This article presents an easy method to get YTD data grouped by months in T-SQL.

Script to calculate the Median value for SQL Server data

Tue, 08 Nov 2011 07:00:00 UT

The standard SQL language has a number of aggregate functions like: SUM, MIN, MAX, AVG, but a common statistics function that SQL Server does not have is a built-in aggregate function for median. The median is the value that falls in the middle of a sorted resultset with equal parts that are smaller and equal parts that are greater. Since there is no built-in implementation for the median, the following is a simple solution I put together to find the median.

Grouping Sets

Tue, 30 Aug 2011 06:00:00 UT

How well do you know MAX?

Fri, 05 Aug 2011 06:00:00 UT

AVG function

Tue, 21 Jun 2011 06:00:00 UT

SQL Function to get Max, Min values from given collection of values

Thu, 20 Jan 2011 07:00:00 UT

This func returns the max value,min value and count of values from collection of values

Using OVER with an Aggregate Function

Thu, 04 Nov 2010 06:00:00 UT

Generating SubTotals using GROUPING

Fri, 16 Nov 2012 07:00:00 UT

This article explains how to use the GROUPING clause to generate subtotals for rows in a very easy fashion.

COUNT_BIG

Tue, 09 Mar 2010 07:00:00 UT

Three Sample reports for the Automated DBA: Space Usage SnapShotter

Mon, 13 Jul 2009 06:00:00 UT

1100 largest indexes by total buffer cache usage; 100 largest tables by total reserved pages; Largest tables in each database with running total of space usage and growth since last snapshot

Median Workbench

Wed, 06 May 2009 06:00:00 UT

SQL Server database engine doesn't have a MEDIAN() aggregate function. This is probably because there are several types of median, such as statistical, financial or vector medians. Calculating Medians are essentially a row-positioning task, since medians are the middle value of an ordered result. Easy to do in SQL? Nope. Joe Celko explains why.

SUM of FLOAT inconsistency

Mon, 13 Oct 2008 06:00:00 UT

Accessing and changing data 2008

Tue, 23 Sep 2008 06:00:00 UT

Summarizing Data with Aggregate Queries - SQL School Video

Thu, 28 Aug 2008 06:00:00 UT

Learn how to summarize the values of your data using aggregate functions such as COUNT(), SUM(), and AVG() from MVP Kathi Kellenberger. Grouping and aggregate filters are covered as well.

Calculating Mathematical Values in SQL Server

Thu, 07 Aug 2008 06:00:00 UT

In our application we have the need to perform mathematical calculations. Right now we are doing so in our front end application. Unfortunately we are starting to experience performance problems with large data sets and differences in calculations due to developers using different logic. We are seeking some other options to perform the calculations. Does SQL Server perform basic mathematical calculations?

Windowed Aggregate functions

Fri, 27 Jun 2008 06:00:00 UT

Aggregating Correlated Sub-Queries

Mon, 29 Oct 2007 06:00:00 UT

Every now and then you may attempt to calculate an aggregate function -- such as SUM() -- on a correlated subquery, only to encounter the following error: