Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Aggregation   (RSS)
Thursday, May 15, 2008 9:39 AM

Query Processing Presentation

Last week, I had the opportunity to talk to the New England SQL Server Users Group . I would like to thank the group for inviting me, Adam Machanic for organizing the event, and Red Gate for sponsoring it. My talk was an introduction to query processing,
Posted by craigfr | 0 Comments
Attachment(s): QPTalk.pdf
Monday, March 31, 2008 2:04 PM

Ranking Functions: RANK, DENSE_RANK, and NTILE

In my previous post , I discussed the ROW_NUMBER ranking function which was introduced in SQL Server 2005. In this post, I'll take a look at the other ranking functions - RANK, DENSE_RANK, and NTILE. Let's begin with RANK and DENSE_RANK. These functions
Posted by craigfr | 0 Comments
Friday, January 18, 2008 11:12 AM

Partial Aggregation

In some of my past posts, I've discussed how SQL Server implements aggregation including the stream aggregate and hash aggregate operators. I also used hash aggregation as an initial example in my introductory post on parallel query execution . In this
Posted by craigfr | 1 Comments
Filed under: ,
Thursday, October 11, 2007 9:13 AM

GROUPING SETS in SQL Server 2008

In my last two posts, I gave examples of aggregation WITH ROLLUP and CUBE . SQL Server 2008 continues to support this syntax, but also introduces new more powerful ANSI SQL 2006 compliant syntax. In this post, I'll give an overview of the changes. First,
Posted by craigfr | 1 Comments
Thursday, September 27, 2007 11:30 AM

Aggregation WITH CUBE

In my last post, I wrote about how aggregation WITH ROLLUP works. In this post, I will discuss how aggregation WITH CUBE works. Like the WITH ROLLUP clause, the WITH CUBE clause permits us to compute multiple "levels" of aggregation in a single statement.
Posted by craigfr | 2 Comments
Friday, September 21, 2007 10:36 AM

Aggregation WITH ROLLUP

In this post, I'm going to discuss how aggregation WITH ROLLUP works. The WITH ROLLUP clause permits us to execute multiple "levels" of aggregation in a single statement. For example, suppose we have the following fictitious sales data. (This is the same
Posted by craigfr | 3 Comments
Monday, July 09, 2007 11:05 AM

PIVOT Query Plans

In my last post , I gave an overview of the PIVOT operator. In this post, I'm going to take a look at the query plans generated by the PIVOT operator. As we'll see, SQL Server generates a surprisingly simple query plan that is essentially just a fancy
Posted by craigfr | 0 Comments
Tuesday, July 03, 2007 11:31 AM

The PIVOT Operator

In my next few posts, I'm going to look at how SQL Server implements the PIVOT and UNPIVOT operators. Let's begin with the PIVOT operator. The PIVOT operator takes a normalized table and transforms it into a new table where the columns of the new table
Posted by craigfr | 6 Comments
Wednesday, September 20, 2006 11:09 AM

Hash Aggregate

In my prior two posts, I wrote about the stream aggregate operator. Stream aggregate is great for scalar aggregates and for aggregations where we have an index to provide a sort order on the group by column(s) or where we need to sort anyhow (e.g., due
Posted by craigfr | 6 Comments
Filed under:
Wednesday, September 13, 2006 1:42 PM

Stream Aggregate

There are two physical operators that SQL Server uses to compute general purpose aggregates where we have a GROUP BY clause. One of these operators is stream aggregate which as we saw last week is used for scalar aggregates . The other operator is hash
Posted by craigfr | 6 Comments
Filed under:
Wednesday, September 06, 2006 12:12 PM

Aggregation

Aggregation refers to the collapse of a larger set of rows into a smaller set of rows. Typical aggregate functions are COUNT, MIN, MAX, SUM, and AVG. SQL Server also supports other aggregates such as STDEV and VAR. I’m going to break this topic down into
Posted by craigfr | 9 Comments
Filed under:
 
Page view tracker