Paul White (@SQL_Kiwi) details a regression bug in RCSI caused by a fix for a different bug. If you are running SQL Server 2008 R2, you should read this.
Continue Reading »Jul 302014
Jul 242014
Erin Stellato of SQLskills compares the impact of adding additional index columns, by choosing the key or the INCLUDE list – with interesting results.
Continue Reading »Jul 222014
Citing several examples, Paul White (@SQL_Kiwi) talks through a cardinality estimation bug that can be difficult to spot.
Continue Reading »Jul 112014
Erin Stellato of SQLskills shows how to use SQL Sentry Plan Explorer and SQL Sentry Performance Advisor to see automatic statistics updates.
Continue Reading »Jul 012014
Paul White (@SQL_Kiwi) has put together a fantastic series on concurrency, the ACID properties of statements and transactions, and isolation levels in SQL Server.
Continue Reading »