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.
Continue Reading »Jun 302014
Jun 252014
Continuing his series on knee-jerk reactions to wait statistics, Paul Randal (@PaulRandal) of SQLskills adds another chapter, this time focusing on PAGEIOLATCH_SH.
Continue Reading »Jun 192014
Jonathan Kehayias (@SQLPoolBoy) of SQLskills discusses predicates in Extended Events, and demonstrates why you need to list state-related predicates last.
Continue Reading »Jun 162014
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.
Continue Reading »Jun 122014
Aaron Bertrand (@AaronBertrand) of SQL Sentry takes a look at some unexpected behavior with the CASE expression and some of its derivatives.
Continue Reading »Jun 102014
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.
Continue Reading »Jun 022014
Paul White (@SQL_Kiwi) looks into a limitation of filtered indexes and demonstrates some dangers involving performance degradation and the risk of deadlocks.
Continue Reading »