2012.12.17

MSSQL

• How It Works: SQL Server (NUMA Local, Foreign and Away Memory Blocks)

  http://blogs.msdn.com/b/psssql/archive/2012/12/13/how-it-works-sql-server-numa-local-foreign-and-away-memory-blocks.aspx
  민석형님이 봐주시면 좋을 듯?
   

• SQL Server Quickie #5 – Bookmark Lookup Deadlocks

  http://www.sqlpassion.at/blog/PermaLink,guid,0536d65c-1f3b-41ec-b309-297c100eb951.aspx

  산타모자 쓰시고 나와서 데드락 설명을 하시네요 발음이~

     

• Azure SQL Database Import/Export Service - Change always brings both challenges and benefits

  http://blogs.msdn.com/b/psssql/archive/2012/12/14/azure-sql-database-import-export-service-change-always-brings-both-challenges-and-benefits.aspx

     

• Instant Index Insight: How to Use sp_BlitzIndex (video)

  http://www.brentozar.com/archive/2012/12/instant-index-insight-how-to-use-sp_blitzindex-video/

  sp_BlitzIndex 괜찮은 스크립트인것 같아요. 개인적으로 그랜 아저씨 스크립트가 더 환상적이라고 생각됩니다. 이 스크립트를 사용하는 방법 동영상입니다.

     

• #0221 - SQL Server - SSMS - Database Properties - Number of Users value

  http://beyondrelational.com/modules/2/blogs/77/Posts/18553/0221-sql-server-ssms-database-properties-number-of-users-value.aspx?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+beyondrelationalmain+%28Technology+stream+from+beyondrelational.com%29

     

• Querying SQL Server Agent Job History Data

  http://www.mssqltips.com/sqlservertip/2850/querying-sql-server-agent-job-history-data/

     

• SQL Server SP_Congifure 변경 사항 캡처

  http://sqlmvp.kr/140175032346

     

MySQL

• Full table scan vs full index scan performance

  http://architects.dzone.com/articles/full-table-scan-vs-full-index?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+zones%2Farchitects+%28Architects+Zone%29

   

   

http://www.mysqlperformanceblog.com/2012/12/14/the-optimization-that-often-isnt-index-merge-intersection/