2014.03.26

   

SQL

   

• How to Add Nonclustered Indexes to Clustered Columnstore Indexes

  http://www.brentozar.com/archive/2014/03/add-nonclustered-indexes-clustered-columnstore-indexes/

   

• SSAS Tabular: Internal Physical Files

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/25/ssas-tabular-internal-physical-files.aspx        

     

• Creating a Disaster Recovery Plan

  http://www.sqlserver-dba.com/2014/03/creating-a-disaster-recovery-plan.html

     

• The Illusion of Updateable Clustered ColumnStore Indexes

  http://www.sqlpassion.at/archive/2014/03/25/the-illusion-of-updateable-clustered-columnstore-indexes

     

• Implementing SQL Server Transaction Retry Logic for failed transactions

  http://www.mssqltips.com/sqlservertip/3188/implementing-sql-server-transaction-retry-logic-for-failed-transactions/

     

• Using EXCEPT to Determine Row Differences

  http://www.sqlservercentral.com/articles/EXCEPT/107520/

     

• Making the Case for INSTEAD OF Triggers ? Part 1

  http://www.sqlperformance.com/2014/03/t-sql-queries/instead-of-triggers-1

     

LINKS

   

• Last Weeks Top "Reading" Links #76

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/24/last-weeks-top-reading-links-76.aspx