If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> Buyer’s Guide: SQL Server Performance Monitors p. 41 | SSMS Tips p. 48<br /> A PENTON PUBLICATION<br /> January 2008<br /> p. 16<br /> DATA WAREHOUSING:<br /> Plan for CHANGE<br /> p. 27<br /> ITZIK BEN-GAN:<br /> STOP Re-Reading<br /> p. 29<br /> KALEN DELANEY:<br /> CACHE in on XML Plans<br /> p. 33<br /> SCRIPTING:<br /> AUTOMATEView &Table Moves<br /> p. 36<br /> DMV:<br /> Get Rid of UNUSED INDEXES<br /> p. 39Buyer's Guide: SQL Server Performance Monitors p. 41<br /> SSMSTips p. 48<br /> The Smart Guide to Building World-Class Applications<br /> www.sqlmag.com Events: www.sqlconnections.com<br /> EPVER<br /> i n<br /> January 2008<br /> mm<br /> <br /> PAY UP TO<br /> 72% LESS<br /> FOR YOUR<br /> BUSINESS<br /> INTELLIGENCEPAY UP TO<br /> ^???J ???<br /> <br /> Dell, Microsoft®, and AMD can help reduce the cost and complexity of<br /> Business Intelligence. Our systems are quick to install, easy to manage,<br /> and<a title=" Januray 2008 page 1" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=1"> Buyer’s Guide: SQL Server Performance Monitors </a> <a title=" Januray 2008 page 2" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=2"> PAY UP TO 72% LESS FOR YOUR BUSINESS INTELLIGENCE</a> <a title=" Januray 2008 page 3" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=3"> Dell, Microsoft®, and AMD can help reduce the cos</a> <a title=" Januray 2008 page 4" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=4"> 21 </a> <a title=" Januray 2008 page 5" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=5"> WWW.SQLMAG.COM Contents </a> <a title=" Januray 2008 page 6" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=6"> "Impressed is the word! Cut our backup times in h</a> <a title=" Januray 2008 page 7" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=7"> Contents </a> <a title=" Januray 2008 page 8" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=8"> Altova® MissionKit™ 2008 – The secret to savings </a> <a title=" Januray 2008 page 9" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=9"> SQL Server as a Data Platform . . . Finally In Sm</a> <a title=" Januray 2008 page 10" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=10"> LETTERS YOUR SQLMAG.COM VOICE MATT</a> <a title=" Januray 2008 page 11" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=11"> Business Objects YOU'VE NEVER SEEN A REPORT DO TH</a> <a title=" Januray 2008 page 12" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=12"> /V ApexSQL wZJl software ApexSQL Studio your One-</a> <a title=" Januray 2008 page 13" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=13"> READER TO READER T-SQL Function Finds Almos</a> <a title=" Januray 2008 page 14" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=14"> READER TO READER LISTING 2: CodeThat Determines</a> <a title=" Januray 2008 page 15" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=15"> For SQL Server consolidation, there’s only one so</a> <a title=" Januray 2008 page 16" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=16"> EnhanceReportingServiceswith thetechnologyofthefu</a> <a title=" Januray 2008 page 17" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=17"> My PerformancePoint ServerWish List PPS offers s</a> <a title=" Januray 2008 page 18" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=18"> COVER STORY Anne Grubb (agrubb@window</a> <a title=" Januray 2008 page 19" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=19"> COVER STORY Ingenuity and solid database ski</a> <a title=" Januray 2008 page 20" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=20"> COVER STORY 2007 SQL SERVER MAGAZINE INNOVATORS </a> <a title=" Januray 2008 page 21" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=21"> ?JÊI7F;H<;9J<?J ?DJHE:K9?D=J>;IJEH</a> <a title=" Januray 2008 page 22" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=22"> Go Ahead... Ring the Bell After all— we are you</a> <a title=" Januray 2008 page 23" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=23"> 2007 SQL SERVER MAGAZINE INNOVATORS COVER STORY </a> <a title=" Januray 2008 page 24" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=24"> COVER STORY 2007 SQL SERVER MAGAZINE INNOVATORS </a> <a title=" Januray 2008 page 25" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=25"> GrAeTaicktetetor Growth ServiceU gains 99.999% u</a> <a title=" Januray 2008 page 26" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=26"> your competiti</a> <a title=" Januray 2008 page 27" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=27"> user normally accesses the primary datacenter in </a> <a title=" Januray 2008 page 28" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=28"> </a> <a title=" Januray 2008 page 29" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=29"> DataWarehousing: Slowly Changing DIMENSIONS Whe</a> <a title=" Januray 2008 page 30" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=30"> FEATURE Editor’s Tip M</a> <a title=" Januray 2008 page 31" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=31"> FEATURE SQL Server Read-Consistency PROBLEMS, </a> <a title=" Januray 2008 page 32" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=32"> FEATURE READ-CONSISTENCY PROBLEMS LISTING 2: F</a> <a title=" Januray 2008 page 33" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=33"> READ-CONSISTENCY PROBLEMS FEATURE There</a> <a title=" Januray 2008 page 34" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=34"> April 20-23, 2008 Marriott Orlando World Center </a> <a title=" Januray 2008 page 35" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=35"> Examining XML Plans </a> <a title=" Januray 2008 page 36" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=36"> FEATURE EXAMINING XML PLANS IN CACHE </a> <a title=" Januray 2008 page 37" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=37"> EXAMINING XML PLANS IN CACHE FEATURE Figure 1.</a> <a title=" Januray 2008 page 38" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=38"> FEATURE MOVING TABLES FILEGROUPS: </a> <a title=" Januray 2008 page 39" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=39"> MOVE TABLES BETWEEN FILEGROUPS FEATURE LISTING </a> <a title=" Januray 2008 page 40" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=40"> FEATURE Figure 1 Changin</a> <a title=" Januray 2008 page 41" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=41"> A SQL Server 2005 DMV CYoleuarnIsnUdepxes Get sy</a> <a title=" Januray 2008 page 42" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=42"> FEATURE CLEAN UP YOUR INDEXES LISTING 2: Findi</a> <a title=" Januray 2008 page 43" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=43"> SQL Server Performance Monitors Track and optimi</a> <a title=" Januray 2008 page 44" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=44"> BUYER’S SQL SERVER PERFORMANCE MONITORSGUIDE Com</a> <a title=" Januray 2008 page 45" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=45"> SQL SERVER PERFORMANCE MONITORS BUYER’S GUIDE Mo</a> <a title=" Januray 2008 page 46" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=46"> 3 Info-packed EXCHANGE 2007 Mastery Series Hosted</a> <a title=" Januray 2008 page 47" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=47"> Bytes from the Blog www.sqlmag.com/go/industrybyt</a> <a title=" Januray 2008 page 48" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=48"> NEW PRODUCTS Editor’s Tip Got a g</a> <a title=" Januray 2008 page 49" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=49"> Connecting readers with the products and ser</a> <a title=" Januray 2008 page 50" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=50"> The Michael Otey (motey@sqlmag.com) </a> <a title=" Januray 2008 page 51" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=51"> SQLSENTRYA Event Manager The Best Database Manage</a> <a title=" Januray 2008 page 52" href="https://secure.viewer.zmags.com/publication/9828b3f9?page=52"> Download a FREE 14-da</a>