Microsoft SQL Server 2014 Query Tuning & Optimization

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 tunin [...]
Visa längre beskrivning

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