2013.03.13

   

SQL

   

• ADMINISTERING SQL SERVER 2012 RUNNING ON WINDOWS SERVER CORE

  http://thomaslarock.com/2013/03/administering-sql-server-running-on-server-core

     

• Getting error while parsing XML data to Sql Server

  http://beyondrelational.com/modules/3/ask/questions/19128/getting-error-while-parsing-xml-data-to-sql-server.aspx

     

• Select all SQL Server Functions

  http://www.sqlserver-dba.com/2013/03/select-all-sql-server-functions.html

     

• Day 30 of 31 Days of Disaster Recovery (T-SQL Tuesday #40): Using Partial Availability and Initialize from Backup to Replicate a Partial Database

  http://www.sqlsoldier.com/wp/sqlserver/day30of31daysofdisasterrecoveryusingpartialavailabilityandinitializefrombackuptoreplicateapartialdatabase

     

• SQL Server – Generating PERMUTATIONS using T-Sql

  http://beyondrelational.com/modules/24/syndicated/463/Posts/19135/sql-server-generating-permutations-using-t-sql.aspx

     

• Using Filtered Indexes to Improve Performance

  http://www.sql-server-performance.com/2013/sql-server-filtered-indexes-performance

     

• SQL SERVER – Avoid Using Function in WHERE Clause – Scan to Seek

  http://blog.sqlauthority.com/2013/03/12/sql-server-avoid-using-function-in-where-clause-scan-to-seek/

     

• Filegroups and Non-Clustered Indexes

  http://sqlblog.com/blogs/rob_farley/archive/2013/03/12/filegroups-and-non-clustered-indexes.aspx

     

ETC

   

• [입 개발] Redis Pub/Sub 시스템은 일반적인 Message Queue와 다르다.

  http://charsyam.wordpress.com/2013/03/12/%EC%9E%85-%EA%B0%9C%EB%B0%9C-redis-pubsub-%EC%8B%9C%EC%8A%A4%ED%85%9C%EC%9D%80-%EC%9D%BC%EB%B0%98%EC%A0%81%EC%9D%B8-message-queue%EC%99%80-%EB%8B%A4%EB%A5%B4%EB%8B%A4/