2014.02.26

   

SQL

   

• How to analyse SQL Server performance

  http://rusanu.com/2014/02/24/how-to-analyse-sql-server-performance/

   

• Lock Escalations

  http://www.sqlpassion.at/archive/2014/02/25/lock-escalations

     

• Understanding Graphical Execution Plans - Part 3: Analyzing the Plan

  http://www.sqlservercentral.com/articles/Execution+Plans/105810/

     

• Identify SQL Server databases that are no longer in use

  http://www.mssqltips.com/sqlservertip/3171/identify-sql-server-databases-that-are-no-longer-in-use/

     

• Database size limitation in SQL Express

  http://blogs.msdn.com/b/arvindsh/archive/2014/02/25/database-size-limitation-in-sql-express.aspx

     

• Seven SQL Server Under-Used Utilities

  https://www.simple-talk.com/sql/database-administration/seven-sql-server-under-used-utilities/

   

• SQL SERVER ? sp_refreshview ? How to update the metadata of view

  http://raresql.com/2014/02/25/sql-server-sp_refreshview-how-to-update-the-metadata-of-view/

     

• AlwaysOn Availability Groups and Automation

  http://joedantoni.wordpress.com/2014/02/25/alwayson-availability-groups-and-automation/

     

• Achieving High SQL Server Availability: RPO and RTO Strategy

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/25/achieving-high-sql-server-availability-rpo-and-rto-strategy.aspx

     

• Excel: Using Inquire

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/25/excel-using-inquire.aspx

     

• What is HDInsight?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/25/what-is-hdinsight.aspx