2014.05.26

   

SQL

   

• Adventures with SQL Server & perfmon Part 1: Resource Governor & Query Memory

  http://sql-sasquatch.blogspot.kr/2014/05/adventures-with-sql-server-and-perfmon.html

     

• Adventures with SQL Server & perfmon Part 2: TokenAndPermUserStore & spinlock suspects

  http://sql-sasquatch.blogspot.kr/2014/05/adventures-with-sql-server-perfmon-part.html

   

• How to Work Around Standard Edition's Limits [Video]

  http://www.brentozar.com/archive/2014/05/work-around-standard-editions-limits-video/

     

• Can you partition a temporary table?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/23/can-you-partition-a-temporary-table.aspx

     

• The overhead of #temp table creation tracking

  http://sqlperformance.com/2014/05/t-sql-queries/overhead-temp-table-tracking

   

• Table Pattern: Rotating Log / Ring Buffer

  http://kejser.org/table-pattern-rotating-log-ring-buffer/

     

• SQL Server 2008 Service Pack 3 Cumulative Update 17

  http://www.sqlskills.com/blogs/glenn/sql-server-2008-service-pack-3-cumulative-update-17

   

• CREATE ASYMMETRIC KEY ? How to Generate an Asymmetric Key

  http://sqlity.net/en/2417/create-asymmetric-key/

     

• Can you partition a temporary table?

  http://jasonbrimhall.info/2014/05/23/can-you-partition-a-temporary-table/

     

     

LINKS

   

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

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

   

• Friday Followup For May 23, 2014

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/23/friday-followup-for-may-23-2014.aspx

     

Other

   

• 2014 JVM 테크니컬 리더들에 대한 개인적 소견

  http://beyondj2ee.wordpress.com/2014/05/23/2014-jvm-%ED%85%8C%ED%81%AC%EB%8B%88%EC%BB%AC-%EB%A6%AC%EB%8D%94%EB%93%A4%EC%97%90-%EB%8C%80%ED%95%9C-%EA%B0%9C%EC%9D%B8%EC%A0%81-%EC%86%8C%EA%B2%AC/

     

• (SFTW) SQL Server Links 23/05/14

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

     

• PostgreSQL Gets Better NoSQL Capabilities

  http://www.infoq.com/news/2014/05/postgresql-9-4

     

• MySQL soon to store system tables in InnoDB

  http://www.tocker.ca/2014/05/22/mysql-soon-to-store-system-tables-in-innodb.html