2014.03.13

   

SQL

   

• A True SQL OS

  http://voiceofthedba.wordpress.com/2014/03/12/a-true-sql-os/

     

• Troubleshoot Database Concurrency in SQL Server with sp_locks

  http://www.sql-server-performance.com/2014/concurrency-sp-locks/

     

• Using whoami to check for instant file initialization

  http://sqlblog.com/blogs/tibor_karaszi/archive/2014/03/12/using-whoami-to-check-for-instant-file-initialization.aspx

     

• Extended Events ? It Doesn't Have to be Hard

  http://www.brentozar.com/archive/2014/03/extended-events-doesnt-hard/

     

• SQL 2012 datetime rounding issue

  http://www.sqlserver-dba.com/2014/03/sql-2012-datetime-rounding-issue.html

     

Other

   

• MySQL ? How to do Straight Join in MySQL?

  http://www.sqlserver.co.uk/index.php/mysql-how-to-do-straight-join-in-mysql/