Category: SQL Server 2014

SQL Server 2014 is now at Service Pack 3, with plenty of enhancements back-ported from recent SQL Server 2016, 2017, and 2019 updates.
Jonathan Kehayias (@SQLPoolBoy) takes a closer look at a new trace flag that allows you to process multiple concurrent statistics updates on the
Aaron Bertrand talks about new arguments to SERVERPROPERTY() that make @@VERSION even more obsolete (and changes that make @@VERSION problematic).
Glenn Berry (@GlennAlanBerry) provides some blueprints for how to decide whether newer processors are worth the investment to improve your O
Erin Stellato of SQLskills demonstrates that, while incremental statistics can help with maintenance, they are ignored by the optimizer.
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 of SQLskills provides details about the best Intel processors available for a variety of server classes and SQL Server 2014 workloads.
Aaron Bertrand reveals that the Books Online content for SQL Server 2014 is finally fully available, and shows two ways to perform installation.
1 2

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More

Get a Free 2-Week Trial

Start your free trial of any of our products today.

Free Trial

2-Week Trial