May 13, 2024
4 minute read
SQL Server Optimization is a topic focused on improving the performance of Microsoft SQL Server databases. It encompasses tactics and techniques used to ensure that queries and operations within a database are executed efficiently and effectively. This optimization process involves identifying bottlenecks, tuning queries, and implementing best practices to reduce response times and enhance overall database performance.
Why Learn SQL Server Optimization?
cjz9s4|
Find a path to becoming a SQL Server Optimization. Learn more at:
OpenCourser.com/topic/cjz9s4/sql
Reading list
We've selected 11 books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
SQL Server Optimization.
A good introduction to SQL Server performance tuning and optimization techniques, focusing on SQL Server 2019.
A comprehensive guide to understanding and analyzing SQL Server execution plans, essential for optimizing query performance.
A collection of articles by SQL Server MVPs on various aspects of performance tuning and optimization.
A deep dive into the internal workings of SQL Server, providing insights into how it processes and optimizes queries.
A comprehensive handbook covering all aspects of SQL Server performance tuning, from query optimization to hardware configuration.
An in-depth exploration of the internal architecture of SQL Server 2016, focusing on performance-related features.
A collection of recipes covering various aspects of SQL Server 2019 administration, including performance tuning.
A guide to using SQL Server Profiler to identify and resolve performance bottlenecks.
A comprehensive guide to SQL Server 2017 performance tuning and optimization, covering both on-premises and cloud deployments.
A deep dive into query tuning techniques for SQL Server 2019, including advanced topics such as adaptive query processing.
A comprehensive guide to SQL Server database administration, covering performance tuning as one of its many topics.
For more information about how these books relate to this course, visit:
OpenCourser.com/topic/cjz9s4/sql
Save
