Field-tested techniques for optimizing SQL Server 2014 databases and applications for speed and performance Microsoft SQL Server 2014 Query Tuning & Optimization reveals how to get peak performance from your queries and applications. The book covers the powerful Query Optimizer, advance query tuning, little-understood SQL Server features that boost query performance, and troubleshooting techniques for underperforming queries. Limitations within SQL Server, including work-arounds, are addressed in-depth. Big data, OLTP databases, data warehouse tuning, and column store indexes are also discussed. Ready-to-use techniques for boosting performance of SQL Server databases, applications, and data warehouses Author Benjamin Nevarez has spent the past 14 years speaking, blogging, and perfecting optimization techniques for SQL Server Advanced troubleshooting tips for dealing with existing queries that are running poorly
Product code: ALHMX
Publisher: McGraw-Hill Education - Europe
Dimensions: 23.3cm x 18.8cm
Publish date: 01/10/2014
Help our customers make the best choices by telling everyone what you think about this product.
There are currently no customer reviews for this product. Why not be the first?