Welcome to MSDN Blogs Sign in | Join | Help

September 2007 - Posts

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
Thursday, September 06, 2007 3:42 PM

Maintaining Unique Indexes

Consider the following schema: CREATE TABLE T (PK INT PRIMARY KEY, A INT, B INT) CREATE INDEX TA ON T(A) CREATE UNIQUE INDEX TB ON T(B) INSERT T VALUES (0, 0, 0) INSERT T VALUES (1, 1, 1) Now suppose we run the following update statement: UPDATE T SET
Posted by craigfr | 5 Comments
Filed under:
 
Page view tracker