2014.04.17

   

SQL

   

• The Read Committed Isolation Level - Paul White

  http://www.sqlperformance.com/2014/04/t-sql-queries/the-read-committed-isolation-level

   

• Cardinality Estimation for Disjunctive Predicates in SQL Server 2014 - Paul White

  http://sqlblog.com/blogs/paul_white/archive/2014/04/15/cardinality-estimation-for-disjunctive-predicates-in-2014.aspx

     

• SQL Server 2014 Buffer Pool Extensions

  http://www.brentozar.com/archive/2014/04/sql-server-2014-buffer-pool-extensions/

   

• A ever-increasing Clustered Key value doesn't scale!

  http://www.sqlpassion.at/archive/2014/04/15/an-ever-increasing-clustered-key-value-doesnt-scale

     

• Why is Affinity Mask Negative in sp_configure?

  http://www.pythian.com/blog/why-is-affinity-mask-negative-in-sp_configure/

     

• Searching for Strings in SQL Server Databases

  https://www.simple-talk.com/sql/t-sql-programming/searching-for-strings-in-sql-server-databases-/

     

• Simple-Talk SQL Server Backup Crib Sheet

  https://www.simple-talk.com/sql/backup-and-recovery/simple-talk-sql-server-backup-crib-sheet

     

• SQL intersection slides and samples

  http://www.sqlperformance.com/2014/04/sql-performance/sql-intersection-slides-and-samples

     

• [SQL Snacks Video] SQL Server Table Partitioning 102

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/15/sql-snacks-video-sql-server-table-partitioning-102.aspx

     

• FileTable?Adding a file to a folder

  http://voiceofthedba.wordpress.com/2014/04/16/filetableadding-a-file-to-a-folder/

     

• Optional Parameters Causing Index Scans

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/15/optional-parameters-causing-index-scans.aspx

     

• Parallel Data Warehouse (PDW) AU1 released

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/15/parallel-data-warehouse-pdw-au1-released.aspx

     

LINKS

   

• LAST WEEKS TOP "READING" LINKS #79

  http://www.jasonstrate.com/2014/04/last-weeks-top-reading-links-79/

     

Other

   

• 왜 개발자들은 이전 개발자를 나쁜 사람으로 모는가?

  http://www.mimul.com/pebble/default/2014/04/16/1397645377481.html

     

• percona-millipede ? Sub-second replication monitor

  http://www.mysqlperformanceblog.com/2014/04/15/percona-millipede-sub-second-replication-monitor/