2014.02.06

   

   

SQL

   

• Database Backup with Memory-Optimized Tables

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/02/05/database-backup-with-memory-optimized-tables.aspx

     

• Untold Secrets of SQL Server: What if?

  http://www.pythian.com/blog/untold-secrets-of-sql-server-what-if/

     

• Statistics Matter on Temp Tables, Too

  http://www.brentozar.com/archive/2014/02/statistics-matter-on-temp-tables-too/

     

• Transactions: What commands aren't allowed?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/05/transactions-what-commands-aren-t-allowed.aspx

     

• SQL SERVER ? Retrieve All the Data from VARCHAR(MAX) Column

  http://www.sqlserver.co.uk/index.php/sql-server-retrieve-all-the-data-from-varcharmax-column/

     

• Conditional Aggregates

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/04/conditional-aggregates.aspx

     

• Are your backups enough?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/04/are-your-backups-enough.aspx

     

• As The World Turns: SQL Server NUMA Memory Node and the Operating System Proximity

  http://blogs.msdn.com/b/psssql/archive/2014/02/04/as-the-world-turns-sql-server-numa-memory-node-and-the-operating-system-proximity.aspx

     

• AlwaysOn Availability Groups: Comparing On-Premises Deployments and Azure VM Deployments

  http://blogs.msdn.com/b/sqlcat/archive/2014/02/04/alwayson-availability-groups-comparing-on-premises-deployments-and-azure-vm-deployments.aspx

     

• Forum Etiquette: How to post Reporting Services problems

  http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/106306/

     

   

Other

   

• 16000 active connections ? Percona Server continues to work when others die

  http://www.mysqlperformanceblog.com/2014/02/04/16000-active-connections-percona-server-continues-work-others-die/