2013.03.14

SQL

   

• Break large delete operations into chunks

  http://www.sqlperformance.com/2013/03/io-subsystem/chunk-deletes

   

• Find missing indexes using SQL Servers index related DMVs

  http://basitaalishan.com/2013/03/13/find-missing-indexes-using-sql-servers-index-related-dmvs/

     

• SQL Server Backup to Cloud – Managing Interrupted backups

  http://blogs.msdn.com/b/sqlosteam/archive/2013/03/12/sql-server-backup-to-cloud-managing-interrupted-backups.aspx

     

• Break large delete operations into chunks

  http://www.sqlperformance.com/2013/03/io-subsystem/chunk-deletes

     

• Log Shipping Part 2: When Disaster Strikes (video)

  http://www.brentozar.com/archive/2013/03/log-shipping-part-2-when-disaster-strikes-video/

     

• Cost of Process Defrag in Analysis Services Tabular #ssas #tabular

  http://sqlblog.com/blogs/marco_russo/archive/2013/03/13/cost-of-process-defrag-in-analysis-services-tabular-ssas-tabular.aspx

     

• Getting Started with Extended Events in SQL Server 2012

  https://www.simple-talk.com/sql/database-administration/getting-started-with-extended-events-in-sql-server-2012/

     

• Configuring "drill to details" behavior in PowerPivot: Part 1

  http://beyondrelational.com/modules/24/syndicated/477/Posts/19139/configuring-drill-to-details-behavior-in-powerpivot-part-1.aspx

     

ETC

   

• MySQL Backup tools used by Percona Remote DBA for MySQL

  http://www.mysqlperformanceblog.com/2013/03/13/mysql-backup-tools-used-by-percona-remote-dba-for-mysql/        

     

• Linux에서 sysstat 설치하기

  http://beyondj2ee.wordpress.com/2013/03/13/linux%EC%97%90%EC%84%9C-sysstat-%EC%84%A4%EC%B9%98%ED%95%98%EA%B8%B0/