2014.04.08

   

SQL

   

• New Performance Tuning using Wait Statistics Whitepaper

  http://www.sqlskills.com/blogs/jonathan/new-performance-tuning-using-wait-statistics-whitepaper

   

• Updated "How to Think Like SQL Server" Videos        

  http://www.brentozar.com/archive/2014/04/updated-think-like-sql-server-videos/

     

• Selecting a Processor for SQL Server 2014 ? Part 2

  http://www.sqlperformance.com/2014/03/system-configuration/selecting-a-processor-for-sql-server-2014-2

     

• Enabling Data Compression ? April 2014 Update

  http://shaunjstuart.com/archive/2014/04/enabling-data-compression-april-2014-update/

     

• Where Should You Use a Columnstore Index (with script)?

  http://joedantoni.wordpress.com/2014/04/07/where-should-you-use-a-columnstore-index-with-script/

     

• Maximum IOPS for a 10K or 15K SAS Hard Disk Drive is not 170!

  http://dataidol.com/tonyrogerson/2014/04/07/maximum-iops-for-a-10k-or-15k-sas-hard-disk-drive-is-not-170/

     

• Let's Make Your Life a Little Easier: Strategies for Generating and Optimizing SQL Server

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/07/let-s-make-your-life-a-little-easier-strategies-for-generating-and-optimizing-sql-server.aspx

     

• Improving Performance for Some LIKE "%string%" Searches (SQL Spackle)

  http://www.sqlservercentral.com/articles/SQL+LIKE+SEARCH/108015/

     

• A SQL Cmdlet a Day 2 Piping and Select

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/03/a-sql-cmdlet-a-day-2-piping-and-select.aspx

     

• Free Video On Subselects In MDX

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/07/free-video-on-subselects-in-mdx.aspx

     

• SSIS XML Task

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/07/ssis-xml-task.aspx

     

LINKS

   

• Last Weeks Top "Reading" Links #78

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/07/last-weeks-top-reading-links-78.aspx