2013.02.07

SQL

   

• Msg 5042 - The file cannot be removed because it is not empty and dbcc shrinkfile emptyfile

  http://www.sqlserver-dba.com/2013/02/msg-5042-the-file-cannot-be-removed-because-it-is-not-empty-and-dbcc-shrinkfile-emptyfile.html

     

• SQL Monitor - Using the performance data smartly

  http://www.simple-talk.com/sql/sql-tools/sql-monitor---using-the-performance-data-smartly/

     

• Hive Data Warehouse: Lessons Learned (video)

  http://www.brentozar.com/archive/2013/02/hive-data-warehouse-lessons-learned-video/

     

• Move all SQL Server indexed views to a new filegroup

  http://www.mssqltips.com/sqlservertip/2882/move-all-sql-server-indexed-views-to-a-new-filegroup/

     

• Scope of SET TRANSACTION ISOLATION LEVEL

  http://sqlblog.com/blogs/john_paul_cook/archive/2013/02/05/scope-of-set-transaction-isolation-level.aspx

     

• If you are using indexed views and MERGE, please read this!

  http://www.sqlperformance.com/2013/02/t-sql-queries/another-merge-bug

  Merge에 대한 버그 이슈 야그가 많네요..

     

     

ETC

   

• Hive Data Warehouse: Lessons Learned (video)

  http://www.brentozar.com/archive/2013/02/hive-data-warehouse-lessons-learned-video/

   

• [입 개발] Redis Internals : PubSub

  http://charsyam.wordpress.com/2013/02/06/%EC%9E%85-%EA%B0%9C%EB%B0%9C-redis-internals-pubsub/        

     

• R 사용하기 – 1. Twitter 내용을 검색해서 wordcloud 로 표현하기

  http://dev.kthcorp.com/2013/02/06/r-quickstart-guide-1-twitter-wordcloud/

  요즘 분석 업계에서 R 모르면~ 간첩이죠? 저도 얼마전에 해봤는데 정말 쉽게 표현되더만요..다시 통계 공부나 해야징 ㅠㅠ