2013.03.21

   

SQL

   

• Managing the SQL Server Transaction Log: Dealing with Explosive Log Growth

  https://www.simple-talk.com/sql/database-administration/managing-the-sql-server-transaction-log-dealing-with-explosive-log-growth/

     

• System Center Advisor is now free

  http://blogs.msdn.com/b/psssql/archive/2013/03/20/system-center-advisor-is-now-free.aspx

     

• The Problem with Window Functions and Views

  http://www.sqlperformance.com/2013/03/t-sql-queries/the-problem-with-window-functions-and-views

   

• The Power of the SQL Server Database Owner

  http://www.mssqltips.com/sqlservertip/2907/the-power-of-the-sql-server-database-owner/

     

기타

   

Amazon 클라우드에서 S3 Read/Write 성능 높이는 방법-Partitioning        

http://bcho.tistory.com/730

>> 파일명을 가지고 hashing을 하여 파일을 분산 저장