If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> Attunity SQL Server-CDC for SSIS p. 43 | Security Explorer for SQL Server p. 44<br /> >ltzik Ben-Gan<br /> Using SQL Server Denali<br /> OFFSET/FETCH Filter<br /> Part I p. 20<br /> Managing Multi-Select<br /> Parameters in SSRS p. 26<br /> Utilizing Table Partitions<br /> to Archive OLTP Data p. 29<br /> CLR from the DBA<br /> Point of View i<br /> upzu<br /> Sharpen Your Cloud/Mobile/Virtualization Skills. See details p. 34<br /> Smarter technology for a Smarter Planet:<br /> What database integration means<br /> to this blood sample.<br /> It means doctors in Ethiopia will be able to instantly compare this blood sample to over 41,000 HIV treatment<br /> histories to help their patients receive the best treatment regimen possible. The EuResist Network is helping<br /> doctors predict patient response to various HIV treatments with over 78% accuracy???outperforming 9 out of 10<br /> human experts in a recent study. The tool is built on an IBM analytics s<a title="March 2011 page 1" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=1"> Attunity SQL Server-CDC for SSIS p. 43 | Secu</a> <a title="March 2011 page 2" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=2"> Smarter technology for a Smarter Planet: What da</a> <a title="March 2011 page 3" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=3"> WWW.SQLMAG.COM Contents </a> <a title="March 2011 page 4" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=4"> Subscribe Now to the New r Dev Connections (f</a> <a title="March 2011 page 5" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=5"> Contents </a> <a title="March 2011 page 6" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=6"> EDITORIAL Michael Otey (motey@sql</a> <a title="March 2011 page 7" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=7"> ?????? ^ ^ Affordable Diff/Merge for Database</a> <a title="March 2011 page 8" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=8"> U WOUDTOANNOUNCE Recipient of the Eloq</a> <a title="March 2011 page 9" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=9"> READER TO READER A Data Purge Process T </a> <a title="March 2011 page 10" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=10"> READER TO READER The bank decides to use </a> <a title="March 2011 page 11" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=11"> The new math of consolidation Two virtualized </a> <a title="March 2011 page 12" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=12"> SQL SERVER QUESTIONS ANSWERED Should I Optimiz</a> <a title="March 2011 page 13" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=13"> What happens is that the record is simply m</a> <a title="March 2011 page 14" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=14"> SQL SERVER QUESTIONS ANSWERED the placement shou</a> <a title="March 2011 page 15" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=15"> a bug with increments of 4GB or more. For mo</a> <a title="March 2011 page 16" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=16"> COVER STORY Microsoft's David DeWitt on SQL </a> <a title="March 2011 page 17" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=17"> DEWITT ON QUERY OPTIMIZATION COVER STORY O</a> <a title="March 2011 page 18" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=18"> COVER STORY DEWITT ON QUERY OPTIMIZATION colum</a> <a title="March 2011 page 19" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=19"> Top 10 Steps to Ensuring Data Quality One of th</a> <a title="March 2011 page 20" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=20"> 5. Cleanse the data — You can do things to beauti</a> <a title="March 2011 page 21" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=21"> DEWITT ON QUERY OPTIMIZATION COVER STORY </a> <a title="March 2011 page 22" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=22"> COVER STORY DEWITT ON QUERY OPTIMIZATION join,</a> <a title="March 2011 page 23" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=23"> ??devart www.devart.com on must-have SQL Server</a> <a title="March 2011 page 24" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=24"> FEATURE OFFSET/FETCH, P1 A new SQL Server Denali</a> <a title="March 2011 page 25" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=25"> OFFSET/FETCH FEATURE the second query where I </a> <a title="March 2011 page 26" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=26"> FEATURE OFFSET/FETCH Figure 2 Plan without</a> <a title="March 2011 page 27" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=27"> ORDER BY orderdate DESC, orderid DESC OFFSET</a> <a title="March 2011 page 28" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=28"> FEATURE OFFSET/FETCH the original query form w</a> <a title="March 2011 page 29" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=29"> OFFSET/FETCH FEATURE Figure 8 Plan f</a> <a title="March 2011 page 30" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=30"> FEATURE Managing Multi-Select Parameters in </a> <a title="March 2011 page 31" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=31"> Building the Pick-List Query To populate the pick</a> <a title="March 2011 page 32" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=32"> FEATURE MULTI-SELECT PARAMETERS </a> <a title="March 2011 page 33" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=33"> FEATURE Using Table Partitions to Archive Old </a> <a title="March 2011 page 34" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=34"> FEATURE TABLE PARTITIONS TO ARCHIVE OLTP DATA L</a> <a title="March 2011 page 35" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=35"> TABLE PARTITIONS TO ARCHIVE OLTP DATA FEATURE T</a> <a title="March 2011 page 36" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=36"> FEATURE TABLE PARTITIONS TO ARCHIVE OLTP DATA L</a> <a title="March 2011 page 37" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=37"> TABLE PARTITIONS TO ARCHIVE OLTP DATA FEATURE </a> <a title="March 2011 page 38" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=38"> The Conversation Begins Here APRIL 17-20, 2011</a> <a title="March 2011 page 39" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=39"> 3 CONFERENCES - 1-STOP EXPO - GREAT NETWORKING R</a> <a title="March 2011 page 40" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=40"> FEATURE A Practical Approach to Managing Datab</a> <a title="March 2011 page 41" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=41"> 10MB and will grow in 15 percent increments until</a> <a title="March 2011 page 42" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=42"> FEATURE MANAGING DATABASE SIZE the purpose of </a> <a title="March 2011 page 43" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=43"> Reports are useful when you're working with a</a> <a title="March 2011 page 44" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=44"> FEATURE Common Language Runtime from the DBA </a> <a title="March 2011 page 45" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=45"> COMMON LANGUAGE RUNTIME FEATURE An oversim</a> <a title="March 2011 page 46" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=46"> FEATURE COMMON LANGUAGE RUNTIME LISTING 1: Quer</a> <a title="March 2011 page 47" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=47"> Attunity SQL Server-CDC for SSIS 2.1 I'm always </a> <a title="March 2011 page 48" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=48"> PRODUCT REVIEW Robert Davis </a> <a title="March 2011 page 49" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=49"> SECURITY EXPLORER FOR SQL SERVER PRODUCT REVIEW </a> <a title="March 2011 page 50" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=50"> INDUSTRY BYTES Beginning Performance Tuning wit</a> <a title="March 2011 page 51" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=51"> INDUSTRY BYTES c. Staging </a> <a title="March 2011 page 52" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=52"> The ACKPage B Visual Studio 2010 Database Tools</a> <a title="March 2011 page 53" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=53"> IT MIGHT BE MORE OBVIOUS THAN YOU THINK SQL Sent</a> <a title="March 2011 page 54" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=54"> DOES YOUR SQL SERVER RESEMBLE A CRIME SCENE WHEN </a> <a title="March 2011 page 55" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=55"> BONUS: Mobile Apps Track & Cloud Track &#&+ . + </a> <a title="March 2011 page 56" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=56"> A Decade of Making the Connection 575;,7 >,(78,;</a> <a title="March 2011 page 57" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=57"> % " (,*)7/*'6'/'1(* "& </a> <a title="March 2011 page 58" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=58"> ##! Special Evening Events * $## ("$#'% #</a> <a title="March 2011 page 59" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=59"> # " !" --* + - #0,* % - </a> <a title="March 2011 page 60" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=60"> # " !" --* ) 0&,),%% % + ,#+ </a> <a title="March 2011 page 61" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=61"> # " !" <A6E84F<A:?L FBC;<FG<64G87</a> <a title="March 2011 page 62" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=62"> # " !" - % )&$1 )&+&# +*. +</a> <a title="March 2011 page 63" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=63"> # ! ! !& # ! ! * #- )# + </a> <a title="March 2011 page 64" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=64"> # ! ! #.) # )+ * #- )# + ,* %</a> <a title="March 2011 page 65" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=65"> # ! ! * +$#%**+ % (, *0&, %,</a> <a title="March 2011 page 66" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=66"> </a> <a title="March 2011 page 67" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=67"> # *- *'+ #+G*+) + *&,+H %*(#* </a> <a title="March 2011 page 68" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=68"> # * ) + % ) '&)+*,*) '+ &%* </a> <a title="March 2011 page 69" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=69"> # * -#) &- ) % )&$ *&#+ **+ )</a> <a title="March 2011 page 70" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=70"> ! !& </a> <a title="March 2011 page 71" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=71"> ! - , # % ,*+&$''# + &%* $* </a> <a title="March 2011 page 72" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=72"> ! G86;A<DH8F 9BE 6E84G<A: 6?<8A</a> <a title="March 2011 page 73" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=73"> ! 4EBHA7 G;8 F8EI<68 4CC?<64G<B</a> <a title="March 2011 page 74" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=74"> ! %&& *&#,+ &%*+)" %* $% </a> <a title="March 2011 page 75" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=75"> ! "<I8 BK 8G6 6B@C4E<A: 4A7 </a> <a title="March 2011 page 76" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=76"> $ .!+-$+,- !'/'*#+ '(+ SUNDAY, MA</a> <a title="March 2011 page 77" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=77"> $ +)$+ *. */'*#+ '(+ SUNDAY, MAR</a> <a title="March 2011 page 78" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=78"> ! $ </a> <a title="March 2011 page 79" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=79"> (! $("#</a> <a title="March 2011 page 80" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=80"> ! ! $(770599 72(4</a> <a title="March 2011 page 81" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=81"> + & # #$%#% &$ * % </a> <a title="March 2011 page 82" href="https://secure.viewer.zmags.com/publication/7b4cb26d?page=82"> '5;?<;$5492 3 <+538<;65=5;35> ;3 $29;*?=55?*@9?5</a>