7
Optimize query performance in SQL Server
source link: https://docs.microsoft.com/en-us/learn/paths/optimize-query-performance-sql-server/?WT_mc_id=modinfra-11462-thmaure
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
2500 XP
Optimize query performance in SQL Server
- 2 hr 39 min
- Learning Path
- 3 Modules
Intermediate
Data Analyst
Data Engineer
Database Administrator
Developer
SQL Database
SQL Server
Analyze individual query performance and determine where improvements can be made. Explore performance-related Dynamic Management Objects. Investigate how indexes and database design affect queries.
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
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK