2013.04.04

   

SQL

   

• A SQL Server Hardware Tidbit a Day – Day 3 - Glenn Berry

  http://www.sqlskills.com/blogs/glenn/a-sql-server-hardware-tidbit-a-day-day-3

     

• How to Find Out About the Latest SQL Server Service Packs and Cumulative Updates - Glenn Berry

  http://www.sqlskills.com/blogs/glenn/how-to-find-out-about-the-latest-sql-server-service-packs-and-cumulative-updates

   

• DBCC CHECKDB scalability and performance benchmarking on SSDs - Paul S. Randal

  http://www.sqlskills.com/blogs/paul/dbcc-checkdb-scalability-and-performance-benchmarking-on-ssds        

     

• How Many SQL Server ERRORLOG Files Do I Keep?

  http://itknowledgeexchange.techtarget.com/sql-server/how-many-sql-server-errorlog-files-do-i-keep/

     

• Manage Transaction Logs during Index Rebuild

  http://www.sqlserver-dba.com/2013/04/manage-transaction-logs-during-index-rebuild.html

     

• [Video] Bad SQL Server Advice for DBAs

  http://www.brentozar.com/archive/2013/04/video-bad-sql-server-advice-for-dbas/

     

• My first month as DBA – The right tools for the job        

  http://devjef.wordpress.com/2013/04/03/my-first-month-as-dba-the-right-tools-for-the-job/

  DB 쟁이들을 위한 툴들 소개인데 SSMSBoost툴 쥑이네 ㅎㅎㅎ

     

• SSDT naming confusion cleared up. Somewhat.

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/04/03/ssdt-naming-confusion-cleared-up-somewhat.aspx

     

• A Hazard of Using the SQL Merge Statement

  http://www.sqlservercentral.com/articles/MERGE/97867/

  NOT MATCHED BY SOURCE 문제점이 있네요.

     

• Configure the Flat File Source in SQL Server Integration Services 2012 to read CSV files

  http://www.mssqltips.com/sqlservertip/2923/configure-the-flat-file-source-in-sql-server-integration-services-2012-to-read-csv-files/

     

• A Journey from OLTP to OLAP

  http://www.sql-server-performance.com/2013/from-oltp-to-olap