Tag : SQL Server 2014 - SentryOne Team Blog

Tag: SQL Server 2014

Latest Builds of SQL Server 2014

Latest Builds of SQL Server 2014

SQL Server 2014 is now at Service Pack 2, with plenty of enhancements back-ported from recent SQL Server 2016 updates.

Jonathan Kehayias : Improved Support for Parallel Statistics Rebuilds

Jonathan Kehayias (@SQLPoolBoy) takes a closer look at a new trace flag that allows you to process multiple concurrent statistics updates on the same table.

A "drop column" fix you'll want for SQL Server 2012 / 2014

Aaron Bertrand (@AaronBertrand) cautions about using DROP COLUMN without immediately rebuilding the table. Wasted space is a concern; data loss is worse.

Delayed Durability while Purging Data

Melissa Connors (@MelikaNoKaOi) investigates using SQL Server's delayed durability feature to improve performance while purging data.

New SERVERPROPERTY Options to Help Phase Out @@VERSION

Aaron Bertrand (@AaronBertrand) talks about new arguments to SERVERPROPERTY() that make @@VERSION even more obsolete (and changes that make @@VERSION problematic).

Glenn Berry : Practical Processor Selection for OLTP Workloads

Glenn Berry (@GlennAlanBerry) provides some blueprints for how to decide whether newer processors are worth the investment to improve your OLTP workloads.

Erin Stellato : Incremental Statistics are NOT used by the Query Optimizer

Erin Stellato (@erinstellato) of SQLskills demonstrates that, while incremental statistics can help with maintenance, they are ignored by the optimizer.

Information about the SQL Server 2014 Service Pack 1 snafu

Updated April 17, 2015 : SQL Server 2014 Service Pack 1 has been released, but was quickly pulled. This post explains why and shows how to fix any affected instances.

Glenn Berry : Updated CPU Recommendations for SQL Server 2014

Glenn Berry (@GlennAlanBerry) of SQLskills provides details about the best Intel processors available for a variety of server classes and SQL Server 2014 workloads.

Updated SQL Server 2014 Books Online Content

Aaron Bertrand (@AaronBertrand) reveals that the Books Online content for SQL Server 2014 is finally fully available, and shows two ways to perform installation.

Critical Fixes for 2012 & 2014 Online Index Rebuilds

Over on SQLPerformance.com, Aaron Bertrand (@AaronBertrand) warns about a parallelism bug in SQL Server 2012 and 2014 that could lead to data loss following online index rebuilds, and offers guidance on what to do depending on your current edition and build level.