2014.04.07

   

SQL

   

• Why Index Fragmentation and Bad Statistics Aren't Always the Problem (Video)

  http://www.brentozar.com/archive/2014/04/index-fragmentation-bad-statistics-arent-always-problem-video/

   

• GUID, fragmentation and performance: the eternal flame.

  http://sqlblog.com/blogs/davide_mauri/archive/2014/04/06/guid-fragmentation-and-performance-the-eternal-flame.aspx

     

• Video: SQL Server Performance Tuning with Wait Statistics (Introduction)

  http://www.connectsql.com/2014/04/video-sql-server-performance-tuning.html

     

• SQLServer transaction log writes - 64k aligned?

  http://sql-sasquatch.blogspot.kr/2014/04/sqlserver-transaction-log-writes-64k.html

     

• A SQL Cmdlet a Day 1

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

     

• Getting Started in SQL Server

  http://www.sqlservercentral.com/articles/Career/71608/

     

• High Performance Relational Division in SQL Server

  https://www.simple-talk.com/sql/learn-sql-server/high-performance-relational-division-in-sql-server/

     

• Six Videos To Help You Upgrade your Inner DBA to SQL Server 2014'ness

  http://java.dzone.com/articles/six-videos-help-you-upgrade

     

• SQL Server 2014 Licensing Changes

  http://www.brentozar.com/archive/2014/04/sql-server-2014-licensing-changes/

     

LINKS

   

• Log Buffer #366, A Carnival of the Vanities for DBAs

  http://www.pythian.com/blog/log-buffer-366-a-carnival-of-the-vanities-for-dbas/

     

• Friday Followup For April 4, 2014

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/04/friday-followup-for-april-4-2014.aspx

     

• (SFTW) SQL Server Links 04/04/14

  http://www.johnsansom.com/sftw-sql-server-links-040414/

     

Other

   

• Facebook's Yoshinori Matsunobu on MySQL, WebScaleSQL & Percona Live

  http://www.mysqlperformanceblog.com/2014/04/04/facebooks-yoshinori-matsunobu-mysql-webscalesql-percona-live/

   

• 빠르게 훝어 보는 node.js - #6 MongoDB 연동 (mongo-native)

  http://bcho.tistory.com/889