2013.03.05

안녕하세요. 주디아줌마입니다.
봄인데도 아직도 쌀쌀하네요.^^ 

   

SQL

   

• SQL Server 2012 Diagnostic Information Queries (March 2013)        - 그렌아저씨

  https://sqlserverperformance.wordpress.com/2013/03/03/sql-server-2012-diagnostic-information-queries-march-2013/

  쥑이는 스크립트이죠^^

     

• SQL Server Maintenance Plans and Parallelism – CHECKDB

  http://www.sqlskills.com/blogs/erin/sql-server-maintenance-plans-and-parallelism-checkdb/

  (CHECKDB, CHECKTABLE, CHECKFILEGROUP, and CHECKCATALOG) is single-threaded in Standard Edition에요...

  엔터버젼에서는 max-dop 설정 값에 따라 실행되네요.

   

• Execution Plan Sanitizer v2        

  http://www.sqlskills.com/blogs/jonathan/execution-plan-sanitizer-v2/        

     

• What events are captured in SQL Transaction Logs?                

  http://www.sqlserver-dba.com/2013/02/what-events-are-captured-in-sql-transaction-logs.html

     

• PRESENTATION MATERIALS "A FUNCTION IS A FUNCTION"

  http://www.jasonstrate.com/2013/02/presentation-materials-a-function-is-a-function/

     

• Six Scary SQL Surprises

  http://www.red-gate.com/products/dba/dba-bundle/entrypage/hard-earned-lessons-3

   

• MARCH 2013 – MONTHLY SQL SERVER CHECKLIST

  http://www.jasonstrate.com/2013/03/march-2013-monthly-sql-server-checklist/

   

• LAST WEEKS TOP 10 "READING" LINKS #22

  http://www.jasonstrate.com/2013/03/last-weeks-top-10-reading-links-22

  CHECK~~ http://www.sqlballs.com/2013/02/windows-2012-for-dba-setting-your.html

     

• Log cannot be reused, see the log_reuse_wait_desc column in sys.databases – SQL Server Error 9002        

  http://www.sqlserver-dba.com/2013/03/log-cannot-be-reused-see-the-log_reuse_wait_desc-column-in-sysdatabases-sql-server-error-9002.html

     

• How to recover a SQL Server login password.

  http://www.sqlservercentral.com/articles/password+cracking/96540/

     

• How to move a SQL Server Log Shipped Secondary Database to Different SQL Server

  http://www.mssqltips.com/sqlservertip/2873/how-to-move-a-sql-server-log-shipped-secondary-database-to-different-sql-server/

     

• Loop through Flat Files in SQL Server Integration Services

  http://www.mssqltips.com/sqlservertip/2874/loop-through-flat-files-in-sql-server-integration-services/

     

• Disabling vs. Dropping Indexes

  http://www.brentozar.com/archive/2013/02/disabling-vs-dropping-indexes/

     

• A Look At DBCC CHECKCONSTRAINTS and I/O

  http://www.sqlperformance.com/2013/02/io-subsystem/dbcc-checkconstraints

     

• Import data - solving data convertion and truncation error

  http://beyondrelational.com/modules/2/blogs/70/posts/19094/import-data-solving-data-convertion-and-truncation-error.aspx

  varchar를 쓰면 기본 50byte를 쓴다고 하네요^^

     

• SQL Server - What is the purpose of DENSITY in STATISTICS?

  http://www.sqlservergeeks.com/blogs/AmitBansal/sql-server-bi/756/sql-server-what-is-the-purpose-of-density-in-statistics

     

• SQL Server Statistics Questions We Were Too Shy to Ask

  https://www.simple-talk.com/sql/performance/sql-server-statistics-questions-we-were-too-shy-to-ask/

     

• SQL SERVER – SSMS does NOT Print NULL Values

  http://blog.sqlauthority.com/2013/03/04/sql-server-ssms-does-not-print-null-values/

     

• Defining Post Deployment Scripts in the SQL Server Data Tools

  http://www.mssqltips.com/sqlservertip/2852/defining-post-deployment-scripts-in-the-sql-server-data-tools/

     

• SQL SERVER – Beginning SQL 2012 – Basics of CONVERT and FORMAT Function – Abstract from Joes 2 Pros Volume 5

  http://blog.sqlauthority.com/2013/03/01/sql-server-beginning-sql-2012-basics-of-convert-and-format-function-abstract-from-joes-2-pros-volume-5/

     

• Traversing the Facebook Graph using Data Explorer

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/02/28/traversing-the-facebook-graph-using-data-explorer.aspx

  오호 신기하네요..ㅋㅋ 쥑이네요.. 페이스북 데이타를 가지고 통계까정. 쥑인다. ㅎ.ㅎ

     

• Where do I find the Performance Dashboard for SQL Server 2008?

  http://www.mssqltips.com/sqlservertip/2896/where-do-i-find-the-performance-dashboard-for-sql-server-2008/

     

• Redundant Query Plan Branches

  http://www.sqlskills.com/blogs/joe/redundant-query-plan-branches/

     

기타

   

• NoSQL Style - A Gangnam Style Parody

  http://highscalability.com/blog/2013/3/4/nosql-style-a-gangnam-style-parody.html

  동영상 보시면 대략 NoSQL 감이 오실거에요.ㅋㅋ

     

• The Daily Checklist

  http://zenhabits.net/check/

  DB 데일리 체크가 아닙니다^^

     

• InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

  http://www.mysqlperformanceblog.com/2013/03/04/innodb-full-text-search-in-mysql-5-6-part-2-the-queries/