Jonathan Kehayias (@SQLPoolBoy) shows how VMWare's vCPU hotplug technology can cause serious performance problems in certain vNUMA configurations.
Continue Reading »Dec 302013
Dec 192013
Benjamin Nevarez (@BenjaminNevarez) gives us some insight into the new cardinality estimator in SQL Server 2014 – both how it works as well as how to keep the functionality of the current version of the estimator.
Continue Reading »Dec 172013
SQL Sentry's Aaron Bertrand (@AaronBertrand) highlights a couple of potential problems discovered in various AdventureWorks-based In-Memory OLTP samples out there, and how to work around them.
Continue Reading »Dec 112013
After an initial look at in-memory TVPs at small scale proved promising, SQL Sentry's Aaron Bertrand (@AaronBertrand) takes a closer look at trying to match more values against a much larger table.
Continue Reading »Dec 022013
Glenn Berry (@GlennAlanBerry) of SQLskills.com shares his starting template for database server installation checklists.
Continue Reading »