This course is aimed at Developers who are using SQL Server and wish to expand their knowledge in order to write more performant t-SQL and avoid causing any server bottlenecks.
Basic T-SQL knowledgeBasic Execution Plan Analysis
The purpose of this course is to ensure that Application Developers who use SQL Server understand some SQL Server internals in order to write highly performant and re-usable code when developing their applications.
Module 1: Why Execution Plans?
Module 5: Statistics
Module 2: Indexing
Module 6: Parallelism
Module 3: Optimizer Join Types
Module 7: Cost Based Queries
Module 4: Memory Grants
Module 8: Parameter Sniffing
Module 9: Intermediate Execution Plan Analysis
Stay current with our latest insights
© Copyright 2021 Kutech Solutions Ltd.