2013.01.28

SQL

   

• Common Table Expressions (CTEs), Window Functions, and Views

  http://www.sqlskills.com/blogs/jonathan/ctes-window-functions-and-views/

   

• Optimizing T-SQL queries that change data

  http://sqlblog.com/blogs/paul_white/archive/2013/01/26/optimizing-t-sql-queries-that-change-data.aspx

   

• Column store solutions

  http://sqlscope.wordpress.com/2013/01/27/column-store-solutions/

  Column Store Index는 ent 버젼만 사용하게 되었는데 다음 버젼에서는 해제된다는 내용입니다. 또한 추가적으로

  nonclustered index 생성 가능, 부모테이블 및 파티션 테이블의 읽기 전용으로만 사용되는 부분도 기능 업글된다는 내용이네요.

   

• Continuous deployment of SSDT database projects to Windows Azure using Team Foundation Service

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/01/27/continuous-deployment-of-ssdt-database-projects-to-windows-azure-using-team-foundation-service.aspx

   

• Backup TO DISK, TAPE and now URL - Backup On-Premises SQL Server Databases to Azure Storage

  http://sqlblog.com/blogs/greg_low/archive/2013/01/27/backup-to-disk-tape-and-now-url-backup-on-premises-sql-server-databases-to-azure-storage.aspx

  SQL애져 환경에서 URL을 통한 백업이가능하네요. http://blogs.msdn.com/b/windowsazure/archive/2013/01/24/sql-server-backup-and-restore-to-cloud-simplified.aspx

   

   

• Undoing a change will now undo a check-out in Visual Studio 2012        

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/01/26/undoing-a-change-will-now-undo-a-check-out-in-visual-studio-2012.aspx

   

• SQL Server – Min Memory Per query and performance

  http://www.sqlserver-dba.com/2013/01/sql-server-min-memory-per-query-and-performance.html

   

• SQL Server 2008 Service Pack 3 Cumulative Update 9

  http://sqlserverperformance.wordpress.com/2013/01/25/sql-server-2008-service-pack-3-cumulative-update-9/

  2008/2008R2 지원 서비스는 2014.1.14로 끝나네요. 2008 시스템 쓰시는 분들은 어서 업그레이드 하세요~

   

• Database Backup Integrity Checks with PowerShell

  http://sqlsalt.com/backup-integrity-checks-with-powershell/

   

• SQL Server - Find Default Data location and Default Log Location

  http://www.sqlserver-dba.com/2013/01/sql-server-find-default-data-location-and-default-log-location-.html

   

• Replication Latency

  http://sqlserver365.blogspot.kr/2013/01/replication-latency.html

   

• SQL SERVER – Basic Explanation of Query Hint NOWAIT – How to Not Wait on Locked Query

  http://blog.sqlauthority.com/2013/01/25/sql-server-basic-explanation-of-query-hint-nowait-how-to-not-wait-on-locked-query/

   

ETC

   

• TimingWheel을 이용한 타이머 구현

  http://helloworld.naver.com/helloworld/textyle/267396