2013.04.09

   SQL

   

• End of Extended Lifecycle Support for SQL Server 2000 Service Pack 4

  http://blogs.msdn.com/b/sqlreleaseservices/archive/2013/04/08/end-of-extended-lifecycle-support-for-sql-server-2000-service-pack-4.aspx        

  공식 종료…… SQL2000 GOODBYE~~

     

• A SQL Server Hardware Tidbit a Day – Day 5 - Glenn Berry

  http://www.sqlskills.com/blogs/glenn/a-sql-server-hardware-tidbit-a-day-day-5

     

• A SQL Server Hardware Tidbit a Day – Day 6 - Glenn Berry

  http://www.sqlskills.com/blogs/glenn/a-sql-server-hardware-tidbit-a-day-day-6

     

• A SQL Server Hardware Tidbit a Day – Day 7 - Glenn Berry

  http://www.sqlskills.com/blogs/glenn/a-sql-server-hardware-tidbit-a-day-day-7/

     

• A SQL Server Hardware Tidbit a Day – Day 8 - Glenn Berry

  http://www.sqlskills.com/blogs/glenn/a-sql-server-hardware-tidbit-a-day-day-8

     

• Hyper-Threading Performance

  http://sqlblog.com/blogs/joe_chang/archive/2013/04/08/hyper-threading-performance.aspx        

     

• Get rowcount of all sql tables

  http://www.sqlserver-dba.com/2013/04/get-rowcount-of-all-sql-tables.html

     

• LAST WEEKS TOP "READING" LINKS #27

  http://www.jasonstrate.com/2013/04/last-weeks-top-reading-links-27

     

• SQL Server JOIN Hints

  http://www.mssqltips.com/sqlservertip/2917/sql-server-join-hints/

  조인 힌트에 대한 쉽게 풀이 해놓았는데, 개념 잡기에 좋을 것 같습니다.

     

• DMV-5 : Queries runing are adhoc or proc , single or multi use ?……..sys.dm_exec_cached_plans

  http://mssqlfun.com/2013/04/08/dmv-5-queries-runing-are-adhoc-or-proc-single-or-multi-use-sys-dm_exec_cached_plans/

     

• SQL SERVER – The procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.

  http://blog.sqlauthority.com/2013/04/08/sql-server-the-procedure-attempted-to-return-a-status-of-null-which-is-not-allowed-a-status-of-0-will-be-returned-instead/

     

OTHER

   

• 구루의 기술뉴스 : 구글 Blink 와 페이스북 Home 외 23건

  http://xguru.net/1333?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+xguru+%28Guru%27s+Blog%29

  요즘 Node.js가 인기죠??? 기술 뉴스중에 node.js를 이용하여 1백만 동시 커넥션 처리 쥑이네~~. 세부 항목 중에 DB 항목 부분 관심이 가네요. 제가 뉴스 올리는 것도 여기와 같이 잘 정리해서 올려야 하는 날이 와야 할텐데 ㅠㅠ

     

• Understanding the maximum number of columns in a MySQL table

  http://www.mysqlperformanceblog.com/2013/04/08/understanding-the-maximum-number-of-columns-in-a-mysql-table/

     

• Data-Driven 스타트업 번개장터의 데이터 기록 시스템

  http://quicket-engineering.tumblr.com/post/47446300643/data-driven

  게임 로그 기록할 때 응용하면 좋을 것 같아요. batch insert로 쓰기 성능이 더 빠르죠.. 역시 script는 python으로 공부해놔야 할듯.. 유료 차트도 정말 잘 그려졌네요. ㅎ.ㅎ