This field is missing from the returned result set from the data source.

This warning
The dataset ‘dataset1' contains a definition for the Field ‘column1'. This field is missing from the returned result set...

Using Unary Operators to control Analysis Services hierarchy aggregations

Analysis Services hierarchy aggregations can be easily controlled using unary operators. For example, in accounting there are GL accounts that...

Analytic Functions – PERCENTILE_CONT / PERCENTILE_DISC

This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.

Analytic Functions in SQL...

Miss 24 Hours of PASS ? No problem, all videos are online

All the videos for the sessions at 24 Hours of PASS are available for free.  Check the session schedule for...

MVP Deep Dives 2 – Pre-Order

 
Every couple days, I’ve been checking for it and finally tonight I saw that the upcoming edition of SQL Server...

MVP Deep Dives 2… Pre-Order

Every couple days, I’ve been checking for it and finally tonight I saw that the upcoming edition of SQL Server...

Replacing a SQL Cursor with SSIS

On a forum post recently the questions was asked how to replace a cursor with an SSIS package. This can...

Rows or Range, What’s the difference ?

With the release of Denali CTP3 came an extension of the over clause to allow for a sliding window of...

SQL Server DBA Quiz on BeyondRelational

Friend of my mine and fellow MVP Jecob Sebastian is running SQL Server DBA Quiz 2011 on his community web...

SQL Server Execution Plans

I writequitefrequently about SQL ServerExecution Plans. I started in that area just because that’s how you figure out what a...