2013.08.29

198회 SQLTag Daily Links    

   

SQL

   

• Parameter Sniffing, Embedding, and the RECOMPILE Options - Paul White

  http://www.sqlperformance.com/2013/08/t-sql-queries/parameter-sniffing-embedding-and-the-recompile-options

   

• An implied (not implying) permissions function

  http://www.sqlskills.com/blogs/bobb/an-implying-not-implied-permissions-function/

     

• scan for startup procs Option ? when to use

  http://www.sqlserver-dba.com/2013/08/scan-for-startup-procs-option-when-to-use.html

     

• Query Plans: What Happens when Row Estimates Get High

  http://www.brentozar.com/archive/2013/08/query-plans-what-happens-when-row-estimates-get-high/

     

• Condensing a Delimited List of Integers in SQL Server

  https://www.simple-talk.com/sql/database-administration/condensing-a-delimited-list-of-integers-in-sql-server/

     

• TVPs in SSIS

  http://sqlblog.com/blogs/rob_farley/archive/2013/08/29/tvps-in-ssis.aspx

     

• SQL SERVER ? Tips for SQL Query Optimization by Analyzing Query Plan

  http://blog.sqlauthority.com/2013/08/28/sql-server-tips-for-sql-query-optimization-by-analyzing-query-plan/

     

• SQL Server papers every DBA should read

  http://www.sqlserver-dba.com/2013/08/sql-server-papers-every-dba-should-read.html

  DBA를 위한 좋은 자료들이 많네요^^

     

• SQL Server 2012 성능저하 - 메모리 이슈

  http://blog.naver.com/ioahn/90180021671

     

• Stairway to PowerPivot and DAX - Level 1: Getting Started with PowerPivot and DAX

  http://www.sqlservercentral.com/articles/Stairway+Series/75427/

     

• Defensive Database Programming Free PDF

  http://www.red-gate.com/community/books/defensive-database-programming

     

• SQL Server 2012 Partitioned Index Compression Comparison

  http://www.mssqltips.com/sqlservertip/3033/sql-server-2012-partitioned-index-compression-comparison/

     

• Understanding SQL Server Query Optimization ? Part 1

  http://www.sql-server-performance.com/2013/sql-server-query-optimization-part-1/

     

Other

   

• Testing Intel, Samsung & SanDisk SATA SSD

  http://www.mysqlperformanceblog.com/2013/08/28/testing-intel-samsung-sandisk-sata-ssd/