2013.09.02

   

SQL

   

• SQL Server Internals: Nested Loops Prefetching - Paul White

  http://sqlblog.com/blogs/paul_white/archive/2013/08/31/sql-server-internals-nested-loops-prefetching.aspx

     

• [SQL 2012 query plan enhancement] I want to know why my query is not parallelized

  http://blogs.msdn.com/b/psssql/archive/2013/08/28/i-want-to-know-why-my-query-is-not-parallelized.aspx

     

• Geek City: How old are my statistics?

  http://sqlblog.com/blogs/kalen_delaney/archive/2013/08/31/how-old-are-my-statistics.aspx

     

• LogParser Performance Inserting into SQL Server

  http://www.purplefrogsystems.com/blog/2013/08/logparser-performance-inserting-into-sql-server/

     

• "Unraveling Tangled Code" recording and downloads!

  http://www.midnightdba.com/Jen/2013/08/unraveling-tangled-code-recording-and-downloads/

     

• Using Geekbench 3 to Evaluate Database Server Performance

  http://www.sqlperformance.com/2013/08/io-subsystem/evaluate-server-with-geekbench

     

• Drive Space Monitoring Gets An Update

  http://www.sqlservercentral.com/articles/Administration/71168/

     

• The Database Administrator's Back-to-School Checklist

  http://www.databasejournal.com/features/db2/the-database-administrators-back-to-school-checklist.html

     

• Manual cleanup Change Data Capture for a SQL Server database

  http://www.mssqltips.com/sqlservertip/3003/manual-cleanup-change-data-capture-for-a-sql-server-database/

     

• Is the Master Certification Dead or Will it be Born Again

  http://www.sqlsoldier.com/wp/sqlserver/isthemastercertificationdeadorwillitbebornagain

  오늘은 거의 MCM, MCA 프로그램을 종료했다는 내용으로 많이 이슈화가 되었네요~

     

• Common SQL Server Clustering, AlwaysOn, and High Availability Answers

  http://www.brentozar.com/archive/2013/08/common-sql-server-clustering-alwayson-and-high-availability-answers/

     

Other

   

• SQLite 2탄 ? 데이터와 인덱스 구조!!

  http://gywn.net/2013/09/let-me-know-data-index-of-sqlite/

  지난주 1탄도 올려주셨는데,,^^