As some of you may or may not know, Lukasz Pawlowski and I had presented the deck Building & Deploying Large Scale SSRS farms using Lessons Learned from Customer Deployments (DBA-416-M) at the 2007 SQL PASS conference. In one of our slides, I had indicated inexplictly that "RS runs only on x64 only". I must have been guilty of copying/pasting from some other slides because RS 2005 indeed does work on IA64 (there are many customers that can attest to that). In general, x64 is a more common deployment for RS because it is often less expensive (and IA64 being…
Month: November 2007
Analysis Services: For Distinct Count measure NULL = 0
If you are to look at the table of values where you want to do a distinct count on the ID column ID ColA NULL blah NULL blah 0 blah 3 blah 1 blah 1 blah 2 blah 2 blah Within SQL, you will get a value of 4 in which there are four distinct values, 0, 1, 2, 3 and NULL is not counted. But within Analysis Services, if you were to put a distinct count measure on top of the ID column, you would also get a value of 4 for four distinct values, but those distinct values are…
Denny Lee 