2012.12.11

MSSQL

• TRANSACTION_MUTEX and Multi-Session Transaction Access

  http://www.sqlperformance.com/2012/12/t-sql-queries/transaction-mutex
  재미난 시스템 SP들입니다. 트랜잭션을 따른 세션에서 공유할 수 있게 해주네요.

  

     

  

     

• Joins in single-table queries

  http://sqlblog.com/blogs/rob_farley/archive/2012/12/11/joins-in-single-table-queries.aspx

     

• SQL Server 2012 도움말 설치

  http://sqlmvp.kr/140174756411

     

• Editing sqlcmdvariable nodes in SSDT Publish Profile files using msbuild

  http://sqlblog.com/blogs/jamie_thomson/archive/2012/12/10/editing-sqlcmdvariable-nodes-in-ssdt-publish-profile-files-using-msbuild.aspx

     

• sp_Blitz v14 Adds VLFs, DBCC, Failsafe Operators, and More

  http://www.brentozar.com/archive/2012/12/sp_blitz-v14-adds-vlfs-dbcc-failsafe-operators-and-more/

     

• Query for server DefaultData & DefaultLog folders

  http://sqlblog.com/blogs/jamie_thomson/archive/2012/12/10/query-for-server-defaultdata-defaultlog-folders.aspx

     

• How to add database file to a Log Shipped database in SQL Server

  http://www.mssqltips.com/sqlservertip/2824/how-to-add-database-file-to-a-log-shipped-database-in-sql-server/