2014.03.07

   

SQL

   

• Setting max server memory

  http://sqlblog.com/blogs/tibor_karaszi/archive/2014/03/06/setting-max-server-memory.aspx

  최대 메모리 설정을 T-SQL Script로 바로 볼 수 있네요

     

• Two New TPC-E Benchmark Results for Intel Xeon Ivy Bridge-EX Processors

  http://www.sqlskills.com/blogs/glenn/two-new-tpc-e-benchmark-results-for-intel-xeon-ivy-bridge-ex-processors

     

• SQL Server 2012 AlwaysOn Groups and FCIs Part 2

  http://www.sqlservercentral.com/articles/AlwaysOn/106314/

     

• Different approaches of counting number of rows in a table

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/06/different-approaches-of-counting-number-of-rows-in-a-table.aspx

   

• On Handling Dates in SQL

  https://www.simple-talk.com/sql/t-sql-programming/on-handling-dates-in-sql/

     

• SQL Server Audit Walkthrough

  http://www.sql-server-performance.com/2014/walkthrough-sql-server-audit/

     

• The Worst Database User

  http://www.brentozar.com/archive/2014/03/the-worst-database-user/

     

• Many-table joins in MySQL 5.6

  http://www.mysqlperformanceblog.com/2014/03/06/many-table-joins-mysql-5-6/

     

• AMD Improves Operational Agility with SQL Server 2014 Business Intelligence Solution

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/03/06/amd-improves-operational-agility-with-sql-server-2014-business-intelligence-solution.aspx

     

• Virtual Lab ? Adapter Setup

  http://voiceofthedba.wordpress.com/2014/03/06/virtual-lab-adapter-setup/