Evaluate performance improvements
|
Evaluate possible changes to indexes. Determine the impact of changes to queries and indexes. Explore Query Store hints.
Determine when changing indexes or defining new ones can affect performance, Evaluate wait statistics as an aid in finding areas for performance improvement, Understand how query hints work, and when to use them
Prerequisites
Ability to use tools for running queries against a Microsoft SQL database, either on-premises on cloud-based.
Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
Basic understanding of structure and usage of SQL Server indexes.
Basic understanding of relational database concepts.
User Reviews
Be the first to review “Evaluate performance improvements”
Related Products
Business Analytics
Explore data analysis techniques to drive business performance and decision-making.
Learn Python 3
Learn the basics of Python 3.12, one of the most powerful, versatile, and in-demand programming languages today.
Intro to Data Analysis
Understand the principles of data analysis, including techniques for data collection, cleaning, and interpretation.
Data Analysis with R
Learn how to analyze data using R programming, including statistical modeling and visualization techniques.
Visualize Data with Python
Learn to make effective data visualizations in Python with Matplotlib and Seaborn.
Data Scientist: Analytics Specialist
Data Analysts and Analytics Data Scientists use Python and SQL to query, analyze, and visualize data — and communicate findings.
There are no reviews yet.