SQL Sentry's @AaronBertrand adds a few tidbits to follow up on his popular post on default cursor options in SQL Server.
Continue Reading »Sep 222015
Sep 152015
Glenn Berry (@GlennAlanBerry) provides some blueprints for how to decide whether newer processors are worth the investment to improve your OLTP workloads.
Continue Reading »Sep 112015
Paul White (@SQL_Kiwi) discusses some things to know about INSTEAD OF triggers – from execution plans and worktables to a cardinality estimation bug in SQL 2014.
Continue Reading »