If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> NEC Express5800/R320 P. 37 | Toad for SQL Server 5.0<br /> _______ February 201 I<br /> f The Smart Guide to Building World-Class Applications<br /> 2 ' n i<br /> SSRS 2008 R2<br /> SharePoint<br /> 2010<br /> Add International Maps to<br /> SQL Server 2008 R2's BIDS p. 29<br /> 4 Methods for Purging<br /> Non-Partitioned Data p. 33<br /> r,<br /> Itzik Ben-Gan<br /> 3 Techniques<br /> for Unpivoting<br /> LData |<br /> p.23<br /> <br /> <br /> WWW.SQLMAG.COM<br /> Contents<br /> FEBRUARY 2011 Vol. 13 · No.2<br /> COVER STORY 16<br /> —Stacia Misner<br /> Find out how to install and set up SSRS in<br /> SharePoint integrated mode.<br /> FEATURES 33<br /> 23 Unpivoting Data<br /> —Itzik Ben-Gan<br /> Unpivoting inv<a title="February 2011 page 1" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=1"> NEC Express5800/R320 P. 37 | Toad for SQL Ser</a> <a title="February 2011 page 2" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=2"> </a> <a title="February 2011 page 3" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=3"> WWW.SQLMAG.COM Contents </a> <a title="February 2011 page 4" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=4"> SQLServer [CONNECTIONS) March 27-30, 2011 JOIN</a> <a title="February 2011 page 5" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=5"> Contents </a> <a title="February 2011 page 6" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=6"> EDITORIAL Michael Otey (motey@sql</a> <a title="February 2011 page 7" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=7"> Discover database independence Experience Altov</a> <a title="February 2011 page 8" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=8"> --.???.assa Get Windows IT Pro &Save 58% Off</a> <a title="February 2011 page 9" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=9"> READER TO READER Are Your DMVs Lying to You? </a> <a title="February 2011 page 10" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=10"> READER TO READER the query completed. Note that</a> <a title="February 2011 page 11" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=11"> marter technology for a Smarter ???*?????? What</a> <a title="February 2011 page 12" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=12"> Free Virtual Conference Developers and Administr</a> <a title="February 2011 page 13" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=13"> Why SQL Server Lets You Create Redundant Indexes </a> <a title="February 2011 page 14" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=14"> SQL SERVER QUESTIONS ANSWERED Is SQL Server Up-</a> <a title="February 2011 page 15" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=15"> ??devart www.devart.com on must-have SQL Server</a> <a title="February 2011 page 16" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=16"> TOOL TIME Kevin Kline (kevin.</a> <a title="February 2011 page 17" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=17"> integrate Data Quality Into Your SSIS Workflow </a> <a title="February 2011 page 18" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=18"> COVER STORY SSRS 2008 R2 Install and</a> <a title="February 2011 page 19" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=19"> SSRS AND SHAREPOINT 2010 INTEGRATION COVER S</a> <a title="February 2011 page 20" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=20"> COVER STORY SSRS AND SHAREPOINT 2010 INTEGRATION </a> <a title="February 2011 page 21" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=21"> SSRS AND SHAREPOINT 2010 INTEGRATION COVER S</a> <a title="February 2011 page 22" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=22"> COVER STORY SSRS AND SHAREPOINT 2010 INTEGRATION </a> <a title="February 2011 page 23" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=23"> The new math of consolidation Two virtualized </a> <a title="February 2011 page 24" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=24"> The Conversation Begins Here mobile connections</a> <a title="February 2011 page 25" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=25"> Unpivoting Data Three techniques based on UNPIVOT</a> <a title="February 2011 page 26" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=26"> FEATURE UNPIVOTING DATA UNPIVOT Operator SQL Se</a> <a title="February 2011 page 27" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=27"> unpivoting one set of source columns, SQL Server </a> <a title="February 2011 page 28" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=28"> FEATURE UNPIVOTING DATA To implement t</a> <a title="February 2011 page 29" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=29"> the APPLY operator achieves both steps described </a> <a title="February 2011 page 30" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=30"> *J Join the SharePoint Expert Community SharePo</a> <a title="February 2011 page 31" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=31"> FEATURE Add Custom Maps to SQL Server 2008 R2'</a> <a title="February 2011 page 32" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=32"> FEATURE CUSTOM MAPS Info™ and Epi Map on</a> <a title="February 2011 page 33" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=33"> Subscribe Now to the New r Dev Connections (f</a> <a title="February 2011 page 34" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=34"> efined ??? Relationship f\(# cloud connections </a> <a title="February 2011 page 35" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=35"> FEATURE 4 Ways to Purge Non-Partitioned Da</a> <a title="February 2011 page 36" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=36"> FEATURE PURGE NON-PARTITIONED DATA the transac</a> <a title="February 2011 page 37" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=37"> PURGE NON-PARTITIONED DATA FEATURE rowset is d</a> <a title="February 2011 page 38" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=38"> FEATURE PURGE NON-PARTITIONED DATA Method Asses</a> <a title="February 2011 page 39" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=39"> NEC Express5800/R320 The NEC Express5800/R320 is</a> <a title="February 2011 page 40" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=40"> PRODUCT NEC EXPRESS5800/R320 REVIEW </a> <a title="February 2011 page 41" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=41"> <d Penton. Marketing Services WE KNOW YOUR CUST</a> <a title="February 2011 page 42" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=42"> UitlM Gleaming classes available now! Thursday</a> <a title="February 2011 page 43" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=43"> Toad for SQL Server 5.0, Professional Edition I</a> <a title="February 2011 page 44" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=44"> WINDOWS IT PRO VIP is Educational???with FREE eL</a> <a title="February 2011 page 45" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=45"> Paying It Forward with Project Phoenix It seems </a> <a title="February 2011 page 46" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=46"> INDUSTRY BYTES Megan Keller (m</a> <a title="February 2011 page 47" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=47"> DATABASE ADMINISTRATION Melissa Data Releases SSI</a> <a title="February 2011 page 48" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=48"> NEW PRODUCTS BUSINESS INTELLIGENCE Embarcadero E</a> <a title="February 2011 page 49" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=49"> with Resources from Left-Brain.com Left-Brain.co</a> <a title="February 2011 page 50" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=50"> The ACKPage B SQL Server Denali Features </a> <a title="February 2011 page 51" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=51"> I - PROBLEMS WITH VISIBILITY? SQL SENTRY CAN</a> <a title="February 2011 page 52" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=52"> THIS DOCTOR MAKES HOUSE CALLS! SQL $ ?? ctor </a> <a title="February 2011 page 53" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=53"> BONUS: Mobile Apps Track & Cloud Track &#&+ . + </a> <a title="February 2011 page 54" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=54"> A Decade of Making the Connection 575;,7 >,(78,;</a> <a title="February 2011 page 55" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=55"> % " (,*)7/*'6'/'1(* "& </a> <a title="February 2011 page 56" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=56"> ##! Special Evening Events * $## ("$#'% #</a> <a title="February 2011 page 57" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=57"> # " !" --* + - #0,* % - </a> <a title="February 2011 page 58" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=58"> # " !" --* ) 0&,),%% % + ,#+ </a> <a title="February 2011 page 59" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=59"> # " !" <A6E84F<A:?L FBC;<FG<64G87</a> <a title="February 2011 page 60" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=60"> # " !" - % )&$1 )&+&# +*. +</a> <a title="February 2011 page 61" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=61"> # ! ! !& # ! ! * #- )# + </a> <a title="February 2011 page 62" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=62"> # ! ! #.) # )+ * #- )# + ,* %</a> <a title="February 2011 page 63" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=63"> # ! ! * +$#%**+ % (, *0&, %,</a> <a title="February 2011 page 64" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=64"> </a> <a title="February 2011 page 65" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=65"> # *- *'+ #+G*+) + *&,+H %*(#* </a> <a title="February 2011 page 66" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=66"> # * ) + % ) '&)+*,*) '+ &%* </a> <a title="February 2011 page 67" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=67"> # * -#) &- ) % )&$ *&#+ **+ )</a> <a title="February 2011 page 68" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=68"> ! !& </a> <a title="February 2011 page 69" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=69"> ! - , # % ,*+&$''# + &%* $* </a> <a title="February 2011 page 70" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=70"> ! G86;A<DH8F 9BE 6E84G<A: 6?<8A</a> <a title="February 2011 page 71" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=71"> ! 4EBHA7 G;8 F8EI<68 4CC?<64G<B</a> <a title="February 2011 page 72" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=72"> ! %&& *&#,+ &%*+)" %* $% </a> <a title="February 2011 page 73" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=73"> ! "<I8 BK 8G6 6B@C4E<A: 4A7 </a> <a title="February 2011 page 74" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=74"> $ .!+-$+,- !'/'*#+ '(+ SUNDAY, MA</a> <a title="February 2011 page 75" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=75"> $ +)$+ *. */'*#+ '(+ SUNDAY, MAR</a> <a title="February 2011 page 76" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=76"> ! $ </a> <a title="February 2011 page 77" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=77"> (! $("#</a> <a title="February 2011 page 78" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=78"> ! ! $(770599 72(4</a> <a title="February 2011 page 79" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=79"> + & # #$%#% &$ * % </a> <a title="February 2011 page 80" href="https://secure.viewer.zmags.com/publication/1d2e2be7?page=80"> '5;?<;$5492 3 <+538<;65=5;35> ;3 $29;*?=55?*@9?5</a>