2013.03.12

   

SQL

   

• DISTINCT and ORDER BY

  http://sqlblog.com/blogs/john_paul_cook/archive/2013/03/10/distinct-and-order-by.aspx

     

• Validating Instance-Level Index View and MERGE Optimization Activity

  http://www.sqlskills.com/blogs/joe/validating-instance-level-index-view-and-merge-usage/

  Merge 이슈들에 대한 언급이 나오네요

     

• sp_ssiscatalog v1.0.2.0 now available for download [SSIS]

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/03/12/sp-ssiscatalog-v1-0-2-0-now-available-for-download.aspx

     

• Are Filtered Statistics Useful with Parameterization?

  http://www.sqlskills.com/blogs/joe/are-filtered-statistics-in-unmatched-scenarios/

  헐.... 상수형이 아닐경우 필터 통계를 사용하지 못하네요.

     

• #0247-SQL Server - sp_refreshview - Refresh metadata for non-schema bound view

  http://beyondrelational.com/modules/2/blogs/77/Posts/19103/0247-sql-server-sprefreshview-refresh-metadata-for-non-schema-bound-view.aspx

     

• DMV-2 : Explore the secrets of session…… sys.dm_exec_sessions

  http://beyondrelational.com/modules/24/syndicated/992/Posts/19130/dmv-2-explore-the-secrets-of-session-sysdmexecsessions.aspx

     

• PowerShell SnapIns vs. Modules

  http://beyondrelational.com/modules/24/syndicated/396/Posts/19124/powershell-snapins-vs-modules.aspx

     

• #0246 - SQL Server 2012 - FileStream and FileTable related DMVs and Catalog Views

  http://beyondrelational.com/modules/2/blogs/77/Posts/19107/0246-sql-server-2012-filestream-and-filetable-related-dmvs-and-catalog-views.aspx

     

• SQL Visualization in the Spreadsheet

  http://beyondrelational.com/modules/2/blogs/925/posts/19117/sql-visualization-in-the-spreadsheet.aspx

     

• SQL Server – TSql to find Records matching certain criteria in all the tables of a DB.

  http://beyondrelational.com/modules/24/syndicated/463/Posts/19122/sql-server-tsql-to-find-records-matching-certain-criteria-in-all-the-tables-of-a-db.aspx

     

• Databases Five Years from Today

  http://www.brentozar.com/archive/2013/03/databases-five-years-from-today/

     

• Query Optimization Research Papers

  http://www.benjaminnevarez.com/2013/03/query-optimization-research-papers/

  쿼리 최적화 관련 좋은 링크가 달려있네요^^

     

• LAST WEEKS TOP 20 "READING" LINKS #23

  http://www.jasonstrate.com/2013/03/last-weeks-top-20-reading-links-23/

     

• A TOP Query

  http://sqlblog.com/blogs/rob_farley/archive/2013/03/11/a-top-query.aspx

     

• uantifying the Cost of Compression

  http://blog.kejser.org/2013/03/11/quantifying-the-cost-of-compression/

     

ETC        

   

• MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

  http://www.mysqlperformanceblog.com/2013/03/11/mysql-5-6-vs-5-5-on-the-star-schema-benchmark/

     

• MySQL performance: Impact of memory allocators (Part 2)

  http://architects.dzone.com/articles/mysql-performance-impact