SQLskills' Glenn Berry (@GlennAlanBerry) talks about measuring I/O performance for SQL Server, focusing on latency, IOPS, and sequential throughput.
Continue Reading »May 272015
May 192015
Erin Stellato (@erinstellato) of SQLskills demonstrates that, while incremental statistics can help with maintenance, they are ignored by the optimizer.
Continue Reading »May 132015
Erin Stellato (@erinstellato) demonstrates the benefits of incremental statistics in SQL Server 2014, and also outlines some unexpected behavior.
Continue Reading »May 072015
Paul White (@SQL_Kiwi) concludes his two-part series on SQL Server sort internals, including two new classes specific to In-Memory OLTP in SQL Server 2014.
Continue Reading »May 052015
Tim Radney (@tradney) of SQLskills explains how SQL Server performance can be impacted when using dynamic memory inside Hyper-V virtual machines.
Continue Reading »