2013.02.08

SQL

   

• Tracking page splits using the transaction log        - 폴 랜달?

  http://www.sqlskills.com/blogs/paul/tracking-page-splits-using-the-transaction-log/        

  확장 이벤트 (sqlserver.transaction_log event) 확인 가능하며, 추가적으로 트랜잭션 로그 확인 가능한 방법들을 소개해주시네요.ㅎ

     

• SOMETHING SMELLS: PARAMETER SNIFFING

  http://thomaslarock.com/2013/02/something-smells-parameter-sniffing/

  추가 참고 링크 : http://www.sommarskog.se/query-plan-mysteries.html

     

• (와우!!) Query hint QUERYTRACEON is now documented publically

  http://blogs.msdn.com/b/psssql/archive/2013/02/07/query-hint-querytraceon-is-now-documented-publically.aspx

     

  예) ELECT x FROM correlated WHERE f1 = 0 and f2 = 1 OPTION (QUERYTRACEON 4199)

  TRACE FLAG : 4199, 2335, 2340, 4137, 4138,

     

• Obtaining rowcounts when using Composable DML [T-SQL]        

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/02/07/obtaining-rowcounts-when-using-composable-dml.aspx        

     

• Exploring the Varbinary Type

  http://www.sqlservercentral.com/articles/Data+Types/95761/

     

• Troubleshooting and Fixing SQL Server Page Level Corruption

  http://www.mssqltips.com/sqlservertip/2871/troubleshooting-and-fixing-sql-server-page-level-corruption/

  참고해볼만함 .

     

• Why to use COALESCE instead of ISNULL

  http://sqlblog.com/blogs/john_paul_cook/archive/2013/02/06/why-to-use-coalesce-instead-of-isnull.aspx

     

     

ETC

   

• Performing Full-text Searches in MySQL 5.6

  http://www.databasejournal.com/features/mysql/performing-full-text-searches-in-mysql-5.6.html

   

• Oracle Releases Open Source MySQL 5.6 with NoSQL Features        

  http://www.databasejournal.com/news/oracle-releases-open-source-mysql-5.6-with-nosql-features.html

     

• 2차 인증 소개

  http://helloworld.naver.com/helloworld/textyle/279640

  OTP만 알고 있었는데 다양한 방식이 있네요.

     

• [입 개발] Redis의 mem_fragmentation_ratio 는 어떻게 구할까?

  http://charsyam.wordpress.com/2013/02/07/%EC%9E%85-%EA%B0%9C%EB%B0%9C-redis%EC%9D%98-mem_fragmentation_ratio-%EB%8A%94-%EC%96%B4%EB%96%BB%EA%B2%8C-%EA%B5%AC%ED%95%A0%EA%B9%8C/