SQLskills' Glenn Berry (@GlennAlanBerry) talks about the cost and performance aspects of the Azure virtual machines Microsoft is hoping you start adopting.
Continue Reading »May 292014
May 232014
Aaron Bertrand (@AaronBertrand) of SQL Sentry takes a closer look at the overhead of using Extended Events to track the creation of #temp tables.
Continue Reading »May 212014
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.
Continue Reading »May 142014
Paul White (@SQL_Kiwi) clears up some possible misconceptions about how data modifications work under Read Committed Snapshot Isolation.
Continue Reading »May 072014
Paul White (@SQL_Kiwi) gives us the scoop on READ COMMITTED SNAPSHOT in his continuing series on ACID and transactions in SQL Server.
Continue Reading »May 012014
Erin Stellato (@erinstellato) of SQLskills performs some tests to evaluate the effect end users might expect from automatic updates to statistics.
Continue Reading »