2013.08.22

193회 SQLTag Daily Links                

   

SQL

   

• SQL 2014 features: Extended buffer pool and columnar indexes

  http://searchsqlserver.techtarget.com/tip/SQL-2014-features-Extended-buffer-pool-and-columnar-indexes

     

• SQL 2014 features: Partitioned indexes and memory-optimized tables

  http://searchsqlserver.techtarget.com/tip/SQL-2014-features-Partitioned-indexes-and-memory-optimized-tables

   

• Msg 15173 - Login has granted one or more permission(s). Revoke the permission(s) before dropping the login.

  http://www.sqlserver-dba.com/2013/08/msg-15173-login-has-granted-one-or-more-permissions-revoke-the-permissions-before-dropping-the-login.html

   

• Back To Basics: Files, File Groups and Disks

  http://itknowledgeexchange.techtarget.com/sql-server/back-to-basics-files-file-groups-and-disks/

   

• Performance Comparison of the SQL Server PARSE, CAST, CONVERT and TRY_PARSE, TRY_CAST, TRY_CONVERT Functions

  http://www.mssqltips.com/sqlservertip/3018/performance-comparison-of-the-sql-server-parse-cast-convert-and-tryparse-trycast-tryconvert-functions/        

     

• Suspect_pages 테이블 이해 및 관리

  http://sqlmvp.kr/140195658538

     

• Lots of ways to UNPIVOT a table

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/08/21/lots-of-ways-to-unpivot-a-table.aspx

     

• The Role of Power Users in a Self-Service BI Initiative

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/08/21/the-role-of-power-users-in-a-self-service-bi-initiative.aspx

     

• SSIS Deployment with PowerShell: Adding Environment References

  http://blogs.lessthandot.com/index.php/DataMgmt/ssis/ssis-deployment-with-powershell-adding

     

• Stairway to Database Design Level 2: Domains, Constraints and Defaults

  http://www.sqlservercentral.com/articles/Database+Design/69926/

     

Other

   

• Use TPC-H to create large test data sets

  http://www.sqlpanda.com/2013/08/use-tpc-h-to-create-large-test-data-sets.html#ZRRswYz26LQ1z5ZR.99

   

• Amazon RDS with MySQL 5.6 ? Configuration Variables

  http://www.mysqlperformanceblog.com/2013/08/21/amazon-rds-with-mysql-5-6-configuration-variables/