2013.02.25

SQL

   

• Transaction Log Configuration Issues - 폴

  http://www.sqlperformance.com/2013/02/system-configuration/transaction-log-configuration

  트랜잭션 로그 특성에 대해서 잘 정리해 두셨네요^^

     

• Comparing multiple rows insert vs single row insert with three data load methods

  https://www.simple-talk.com/sql/performance/comparing-multiple-rows-insert-vs-single-row-insert-with-three-data-load-methods/

     

• Recommended reading from mrdenny for February 22, 2013

  http://itknowledgeexchange.techtarget.com/sql-server/recommended-reading-from-mrdenny-for-february-22-2013/

     

• SQL Server Encryption

  http://www.sqlmag.com/article/sql-server/sql-server-encryption-144904

     

• Unable to register .NET framework assembly not in the supported list

  http://blogs.msdn.com/b/psssql/archive/2013/02/23/unable-to-register-net-framework-assembly-not-in-the-supported-list.aspx

   

• Add an extra SQL Transaction log file – ALTER DATABASE ADD LOG

  http://www.sqlserver-dba.com/2013/02/add-an-extra-sql-transaction-log-file-alter-database-add-log.html

   

• CTEs with Multiple Recursive Members, Part 2

  http://www.sqlmag.com/article/tsql/tsql-cte-multiple-recursive-members-144833

     

• SQL SERVER – T-SQL Script to Keep CPU Busy

  http://blog.sqlauthority.com/2013/02/22/sql-server-t-sql-script-to-keep-cpu-busy/

     

ETC

   

• NoSQL for the MSSQL Soul

  http://www.developer.com/db/nosql-for-the-mssql-soul.html

     

• Video: The Difference Between Graph and Relational Databases

  http://architects.dzone.com/articles/video-difference-between-graph

     

• CentOS 5 users: your UTF-8 data is in peril with Perl MySQL

  http://www.mysqlperformanceblog.com/2013/02/22/centos-5-users-your-utf-8-data-is-in-peril-with-perl/