Paul White (@SQL_Kiwi) continues his series on ACID and transaction isolation levels in SQL Server, giving us fair warning about some potential issues with the SNAPSHOT isolation level.
Continuing his series on knee-jerk reactions to wait statistics, Paul Randal (@PaulRandal) of SQLskills adds another chapter, this time focusing on PAGEIOLATCH_SH.
Jonathan Kehayias (@SQLPoolBoy) of SQLskills discusses predicates in Extended Events, and demonstrates why you need to list state-related predicates last.
Following the recent release of SQL Server 2012 Service Pack 2 and SQL Server 2014 Cumulative Update #3, SQL Sentry's Aaron Bertrand (@AaronBertrand) takes a first look at a new performance enhancement and trace flag (2453) aimed at improving cardinality estimates for table variables and table-valued parameters.
Updated July 23, 2014 : Aaron Bertrand (@AaronBertrand) of SQL Sentry warns about a parallelism bug in SQL Server 2012 and 2014 that could lead to data loss following online index rebuilds.
Paul White (@SQL_Kiwi) looks into a limitation of filtered indexes and demonstrates some dangers involving performance degradation and the risk of deadlocks.
SQLskills' Glenn Berry (@GlennAlanBerry) talks about the cost and performance aspects of the Azure virtual machines Microsoft is hoping you start adopting.
SQL Sentry's Aaron Bertrand (@AaronBertrand) shows how you can use Extended Events to track temp table creation and identify which session created which #temp table.
