Does anyone know if the free ePub version been withdrawn or moved? The link appears to be broken.

Indeed. And depending on how you interpret "ensure the view returns the correct results", you may have to alter the view. The 'correct' results may be those which have no...

For those who encounter this in the future, a hotfix is available from Microsoft which addresses the connectivity issue. I have tested it and it works.

See FIX article http://support.microsoft.com/default.aspx?scid=kb;en-us;2717598. While...

As the predicate involves the same field there's no need for nested CASE statements; a single CASE statement will suffice. Moreover, it improves readability:

SELECT

PeriodKey,

...

Thanks to Wayne for an awesome article! And thanks others for great discussion.

There's one point that no one picked up that I find inaccurate:

Note that the estimated execution plan for...

Nice article!

Edit: Please ignore this post. One of those days...

---------------------------------------------------------------------------------------------

It's also interesting to note that ordinal positions returned by a CASE statement are not implicitly resolved to field objects. This...

That's simply not...

Koen Verbeeck (3/13/2012)

---

andrew.diniz (3/13/2012)

---

Consider the scenario where multiple data regions, each sourced from different tables, are to be fed by a single month parameter.

Which table do you source your...

Why not? Many...

RonKyle (3/11/2012)

---

The article should have mentioned that this is very useful for external data sources that would otherwise cause the user to have to wait for several minutes while all...

DBA-640728 (5/6/2009)

---

thank you so much!!! one last question, i did this in my testing environment and worked perfectly; however in my production env i have replication, would this represent a...

Now, if you toggle the default value of the property Delay Validation and set it to true, the validation will be delayed and the package will not be validated at...

To reserve/delete the http namespace you need local admin rights on the box.

See BoL: http://technet.microsoft.com/en-us/library/ms190614(SQL.90).aspx

In your article you write:

"You might be surprised to learn that changing the WHERE clause in the previous statement from "SpecialOfferID <> 1" to "SpecialOfferID = 2" will prevent...