2014.03.21

   

SQL

   

• A cause of high-duration ASYNC_IO_COMPLETION waits

  http://www.sqlskills.com/blogs/paul/cause-high-duration-async_io_completion-waits

   

• Too many files causing RAM pressure? (a.k.a. DynCache to the rescue!)

  http://blogs.msdn.com/b/arvindsh/archive/2014/03/20/too-many-files-causing-ram-pressure-a-k-a-dyncache-to-the-rescue.aspx

   

• After You've Been a DBA, What Do You Do?        

  http://www.brentozar.com/archive/2014/03/dba-career-afterwards/

     

• Understanding LINQ to Join Multiple Tables Where Null Match Are Expected

  http://www.mssqltips.com/sqlservertip/3169/understanding-linq-to-join-multiple-tables-where-null-match-are-expected/

     

• SQL SERVER ? How to Identify the Locks Held by FileTables

  http://raresql.com/2014/03/20/sql-server-how-to-identify-the-locks-held-by-filetables/

     

• MSTVF Fixed Cardinality Value in SQL Server 2014

  http://www.sqlskills.com/blogs/joe/mstvf-fixed-cardinality-value-sql-server-2014

   

• Where's my FileTable space?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/20/where-s-my-filetable-space.aspx        

• Remaining Vigilant, my contribution to #DBAJumpStart ? Part 3

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/20/remaining-vigilant-my-contribution-to-dbajumpstart-part-3.aspx

     

• Grant EXEC on all Stored Procedures to a Role

  http://www.sqlservercentral.com/articles/Permissions/107472/

     

• Pretty Patterns With Power Query And Power Map

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/20/pretty-patterns-with-power-query-and-power-map.aspx