2014.04.03

   

SQL

   

• Bushy Joins- Joe Chang

  http://sqlblog.com/blogs/joe_chang/archive/2014/04/02/bushy-joins.aspx

   

• Build your own server with Supermicro motherboards - Joe Chang

  http://sqlblog.com/blogs/joe_chang/archive/2014/04/02/build-your-own-server-with-supermicro-motherboards.aspx

     

• Deck from "Practical SQL Server Cardinality Estimation"

  http://www.sqlskills.com/blogs/joe/deck-from-practical-sql-server-cardinality-estimation

     

• Tracking Automatic Updates to Statistics

  http://www.sqlperformance.com/2014/04/extended-events/tracking-auto-stats

     

• Are Table Variables as Good as Temporary Tables in SQL 2014?

  http://www.brentozar.com/archive/2014/04/table-variables-good-temp-tables-sql-2014/

   

• 14 SQL Server Indexing Questions We Were Too Shy To Ask        

  https://www.simple-talk.com/sql/performance/14-sql-server-indexing-questions-we-were-too-shy-to-ask/

     

• How much overhead does encryption add to a SQL Server query

  http://www.mssqltips.com/sqlservertip/3196/how-much-overhead-does-encryption-add-to-a-sql-server-query/

     

• Installing SQL Server 2014 (RTM) on Windows Server 2012        

  http://miteshc.wordpress.com/2014/04/02/installing-sql2014-on-win2012r2/

     

• SQL 2012 Setup Rules ? The 'Missing Reference'

  http://blogs.msdn.com/b/arvindsh/archive/2014/04/02/sql-setup-rules-reference.aspx

     

• Setting up and using file tables

  http://sqlscope.wordpress.com/2014/04/02/setting-up-and-using-file-tables/

     

• Availability databases in unhealthy data synchronization state (Error: 35285, Severity: 16, State: 1.)

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/02/availability-databases-in-unhealthy-data-synchronization-state-error-35285-severity-16-state-1.aspx

     

Other

   

• DB-Engines Ranking of database management systems, April 2014

  http://db-engines.com/en/ranking

     

• Redefining ?ssl option

  http://mysqlblog.fivefarmers.com/2014/04/02/redefining-ssl-option/