If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> Michael Otey: Migrating to SQL Server 2008 p. 7<br /> A PENTON PUBLICATION<br /> August 2008<br /> p. 16<br /> BEST of<br /> TechEd p. 29<br /> Excel Services for SharePoint<br /> NotYour Dad’s Excel p. 31<br /> Itzik Ben-Gan<br /> Move Subtrees Using<br /> HIERARCHYID p. 37<br /> SSMS: Hidden Features p. 41<br /> Indexing the Data Warehouse p. 45<br /> Proler vs.Trace p. 47<br /> Sharpen Your Skills<br /> Self-JOINs p. 49<br /> T-SQL 101<br /> CreateTables p. 51Michael Otey: Migrating to SQL Server 2008 P. i<br /> Excel Services for SharePoint<br /> Not Your Dad's Excel p. 31<br /> Itzik Ben-Gan<br /> Move Subtrees Using<br /> HIERARCHYID p 37<br /> SSMS: Hidden Features p. 41<br /> Indexing the Data Warehouse p. 45<br /> Profiler vs.Trace p. 47<br /> Sharpen Your Skills<br /> Self-JOINs p 49<br /> T-SQL 101<br /> Create Tables p. 51<br /> <br /> “30% INCREASE<br /> IN SPEED AND<br /> PERFORMANCE.”<br /> – D<a title="August 2008 page 1" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=1"> Michael Otey: Migrating to SQL Server 2008 p. 7 </a> <a title="August 2008 page 2" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=2"> “30% INCREASE IN SPEED AND PERFORMANCE.” – Da</a> <a title="August 2008 page 3" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=3"> Every month, 23 million people use CareerBuilder.</a> <a title="August 2008 page 4" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=4"> You have one hour to rock your world Embarcader</a> <a title="August 2008 page 5" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=5"> WWW.SQLMAG.COM Contents </a> <a title="August 2008 page 6" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=6"> Change Management Backup and Recovery </a> <a title="August 2008 page 7" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=7"> Contents </a> <a title="August 2008 page 8" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=8"> XMLSpy – XML Tools for Microsoft® Developers </a> <a title="August 2008 page 9" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=9"> Migrating to SQL Server 2008 Its’osonofsoercrmet</a> <a title="August 2008 page 10" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=10"> READER TO READER Find and Replace Keywords </a> <a title="August 2008 page 11" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=11"> & "! !9"!!!!9# % !!9'""9" " *96+**$(**6G6?E7@C</a> <a title="August 2008 page 12" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=12"> ! -&++!+."$$ </a> <a title="August 2008 page 13" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=13"> )$"$ -/)%*-()+!) & $$ 1K=JKL@AFCL@9LLG<9Q</a> <a title="August 2008 page 14" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=14"> )$*&**($)$)%*-( &(% *)*+#$*%( "% 0@=;J=9LAGFG></a> <a title="August 2008 page 15" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=15"> )(*$!$$*(&() $'" 0@==J9G>L@=:A?@=9NQLJ9FK9;LAGF9D</a> <a title="August 2008 page 16" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=16"> (*$(**>+"$ )%"+*%$)%()#""(%($0*%$) (9J?==</a> <a title="August 2008 page 17" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=17"> =JK 9F AFLJG<M;LAGF AFLG L=EHD9L= KLQD=K 9</a> <a title="August 2008 page 18" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=18"> </a> <a title="August 2008 page 19" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=19"> </a> <a title="August 2008 page 20" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=20"> </a> <a title="August 2008 page 21" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=21"> 9;8,;*<=27*=270 ,877.,=270 =8-*B </a> <a title="August 2008 page 22" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=22"> !)%")-&+'))!"++*'+.))!"++* +;LG:=J ! ! #"#""$$</a> <a title="August 2008 page 23" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=23"> EXPERT SPEAKERS • IN-DEPTH SESSIONS • UNPARALLELE</a> <a title="August 2008 page 24" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=24"> READER TO READER the PRIMARY file group to anoth</a> <a title="August 2008 page 25" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=25"> i s L erv "By whe Rob n</a> <a title="August 2008 page 26" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=26"> SQL Server Magazine Congratulates Idera </a> <a title="August 2008 page 27" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=27"> COMMUNITY DIALOG Sqlmag.com Community Dial</a> <a title="August 2008 page 28" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=28"> TOOL TIME MSSQL Blocks and Orphan Finder The</a> <a title="August 2008 page 29" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=29"> MSSQL BLOCKS AND ORPHAN FINDER System Requireme</a> <a title="August 2008 page 30" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=30"> COVER STORY These products will h</a> <a title="August 2008 page 31" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=31"> COVER STORY BRE A KTHROUGH PRODUCT </a> <a title="August 2008 page 32" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=32"> COVER EDITORS’ BESTSTORY SECURIT Y, AUDITING, a</a> <a title="August 2008 page 33" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=33"> YOU CHOOSE. GET TO WHERE YOU WANT TO BE — </a> <a title="August 2008 page 34" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=34"> SQL Server Magazine Congratulates Dell </a> <a title="August 2008 page 35" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=35"> EDITORS’ BEST COVER STORY BACKUP and RECOVERYW</a> <a title="August 2008 page 36" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=36"> COVER STORY EDITORS’ BEST </a> <a title="August 2008 page 37" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=37"> 7bj[hdWj_l[J^_da_d]7XekjC_Yheie\j8ki_d[ii?dj[bb_]</a> <a title="August 2008 page 38" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=38"> COVER EDITORS’ BESTSTORY DAT A BASE MONITORING </a> <a title="August 2008 page 39" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=39"> TOP CONSIDERATIONS for Sizing a Microsoft SQL Ser</a> <a title="August 2008 page 40" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=40"> 4 Adequate disk storage is critical Make sure</a> <a title="August 2008 page 41" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=41"> Spy is the leading XML development platform,” say</a> <a title="August 2008 page 42" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=42"> COVER STORY EDITORS’ BEST </a> <a title="August 2008 page 43" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=43"> STORAGE WINNERS Gold: RamSan-500 Texas Memory Sy</a> <a title="August 2008 page 44" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=44"> "Be an Exceptional DBA. Use SQL Backup." Brad McG</a> <a title="August 2008 page 45" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=45"> FEATURE Awards Recognize The BEST of Tech•Ed 2</a> <a title="August 2008 page 46" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=46"> Master SharePoint with 3Info-pa</a> <a title="August 2008 page 47" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=47"> Introducing Excel Services f</a> <a title="August 2008 page 48" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=48"> FEATURE </a> <a title="August 2008 page 49" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=49"> datasource or another data system that will use a</a> <a title="August 2008 page 50" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=50"> </a> <a title="August 2008 page 51" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=51"> .INFRASTRUCTURE LOG _DAY 48: This is ridiculous</a> <a title="August 2008 page 52" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=52"> FEATURE INTRODUCING EXCEL SERVICES </a> <a title="August 2008 page 53" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=53"> Microsoft SQL Server: The Evo l ut i on from S</a> <a title="August 2008 page 54" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=54"> With the release of SQL Server 7.0, </a> <a title="August 2008 page 55" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=55"> shows an example of an execution plan in SQL Serv</a> <a title="August 2008 page 56" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=56"> OLAP lets end users change the view of displayed </a> <a title="August 2008 page 57" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=57"> Figure 3: Installing SQL Server 2000 on a Virtual</a> <a title="August 2008 page 58" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=58"> growing popularity as a data-interchange format. </a> <a title="August 2008 page 59" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=59"> OLAP analysis isn’t the only kind of analysis org</a> <a title="August 2008 page 60" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=60"> performance. T-SQL is a limited language—limited </a> <a title="August 2008 page 61" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=61"> Microsoft wasn’t just concerned about CLR code se</a> <a title="August 2008 page 62" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=62"> versioning framework used to implement snapshot t</a> <a title="August 2008 page 63" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=63"> Besides tasks and precedence constraints, control</a> <a title="August 2008 page 64" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=64"> to maintain and providing better performance for </a> <a title="August 2008 page 65" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=65"> data to your data warehouse, you should always pe</a> <a title="August 2008 page 66" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=66"> Figure 8: Excel 2007 as SSAS 2008 Data Mining Cli</a> <a title="August 2008 page 67" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=67"> would like to see support for temporal applicatio</a> <a title="August 2008 page 68" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=68"> **** ** *** ** '** %*!))(** $* ** * & </a> <a title="August 2008 page 69" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=69"> Part 2 Move subtrees and convert parent-child re</a> <a title="August 2008 page 70" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=70"> FEATURE HIERARCHYID LISTING 1: Code to Create </a> <a title="August 2008 page 71" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=71"> HIERARCHYID LISTING 3: Code toTest the usp_Rep</a> <a title="August 2008 page 72" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=72"> FEATURE HIERARCHYID LISTING 4: Code to Create </a> <a title="August 2008 page 73" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=73"> FEATURE Digging I NTO Get familiar with s</a> <a title="August 2008 page 74" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=74"> FEATURE DIGGING INTO SSMS </a> <a title="August 2008 page 75" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=75"> and solutions, you’ll see the logic of organizing</a> <a title="August 2008 page 76" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=76"> DEVCONNECTIONS November 10-13 2008 L</a> <a title="August 2008 page 77" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=77"> INDEXING the DataWarehouse Optimize performance </a> <a title="August 2008 page 78" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=78"> FEATURE Author's Tip Is there an “ide</a> <a title="August 2008 page 79" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=79"> Best Practices tor Sizing, Optimizing, and Managi</a> <a title="August 2008 page 80" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=80"> 999 Best Practices for Sizing, Optimizing, and Ma</a> <a title="August 2008 page 81" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=81"> Best Practices for Sizing, Optimizing, and Managi</a> <a title="August 2008 page 82" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=82"> 999 Best Practices for Sizing, Optimizing, and Ma</a> <a title="August 2008 page 83" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=83"> Best Practices for Sizing, Optimizing, and Managi</a> <a title="August 2008 page 84" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=84"> 999 Best Practices for Sizing, Optimizing, and Ma</a> <a title="August 2008 page 85" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=85"> Best Practices for Sizing, Optimizing, and Managi</a> <a title="August 2008 page 86" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=86"> 999 Best Practices for Sizing, Optimizing, and Ma</a> <a title="August 2008 page 87" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=87"> Best Practices for Sizing, Optimizing, and Managi</a> <a title="August 2008 page 88" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=88"> 999 Best Practices for Sizing, Optimizing, and Ma</a> <a title="August 2008 page 89" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=89"> Best Practices for Sizing, Optimizing, and Managi</a> <a title="August 2008 page 90" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=90"> 999 Best Practices for Sizing, Optimizing, and Ma</a> <a title="August 2008 page 91" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=91"> Best Practices for Sizing, Optimizing, and Managi</a> <a title="August 2008 page 92" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=92"> 999 Best Practices for Sizing, Optimizing, and Ma</a> <a title="August 2008 page 93" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=93"> Best Practices for Sizing, Optimizing, and Managi</a> <a title="August 2008 page 94" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=94"> A SPECIAL ADVERTISING SUPPLEMENT TO SOL SERVER MA</a> <a title="August 2008 page 95" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=95"> SQL Server Proler or Server-SideTrace? That is t</a> <a title="August 2008 page 96" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=96"> FEATURE </a> <a title="August 2008 page 97" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=97"> SharpenYour Basic SQL Server Skills Learn how to</a> <a title="August 2008 page 98" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=98"> SQL Server Magazine Congratulates Dell </a> <a title="August 2008 page 99" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=99"> FEATURE T-SQL 101, Lesson6 How to create tables </a> <a title="August 2008 page 100" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=100"> FEATURE T-SQL 101 left out, the table will b</a> <a title="August 2008 page 101" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=101"> T-SQL 101 FEATURE if you tried to insert a reco</a> <a title="August 2008 page 102" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=102"> FEATURE T-SQL 101 Fig</a> <a title="August 2008 page 103" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=103"> Connecting readers with the products and ser</a> <a title="August 2008 page 104" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=104"> The Michael Otey (motey@sqlmag.com)</a> <a title="August 2008 page 105" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=105"> Achieve Ultimate Microsoft® SQL Server® Per</a> <a title="August 2008 page 106" href="https://secure.viewer.zmags.com/publication/a0ea9bfd?page=106"> 24 x 7 Hands-Free SQL Server Index Defragmentatio</a>