1 option
SN Video coding and web development. SQL Server indexing, statistics, and parameter sniffing / Springer.
- Format:
- Video
- Series:
- Academic Video Online
- Language:
- English
- Subjects (All):
- SQL server.
- Data structures (Computer science).
- Database management.
- Statistics--Data processing.
- Statistics.
- Electronic data processing.
- Genre:
- Instructional films.
- Physical Description:
- 1 online resource (73 minutes)
- Other Title:
- SQL Server indexing, statistics, and parameter sniffing
- Springer Nature video coding and web development
- Place of Publication:
- London, England : Springer Nature, 2020.
- Language Note:
- In English.
- System Details:
- video file
- Summary:
- Dive into performance tuning by learning how data is structured and accessed in SQL Server. Learn from this video how to use execution plans, IO metrics, and query timing to identify problematic queries and trace latency directly to missing or incorrect indexes. Also learn about cardinality and how it affects execution plans and overall query performance. Understanding how indexes and statistics work provides a solid foundation for writing better queries and architecting more effective database objects. The knowledge from this video helps you to dive further into procedural TSQL and identify why a stored procedure or ad-hoc query can perform unexpectedly badly. This video examines such cases through a discussion of the causes of poor performance in TSQL procedures along with solutions such as parameter sniffing. In addition, the video demonstrates how local variables perform differently from parameters and how plan reuse can benefit performance. When plan reuse harms performance, the correct solutions will be presented, allowing you to permanently solve a performance challenge without the use of hacks or temporary fixes. This video is for database administrators, developers, and architects who need to write fast and efficient database queries. For database administrators who are asked to troubleshoot slow queries to make them faster. For anyone working against SQL Server who relies upon highly performant queries to perform important tasks.
- Notes:
- Title from resource description page (viewed March 5, 2021).
- OCLC:
- 1245590462
The Penn Libraries is committed to describing library materials using current, accurate, and responsible language. If you discover outdated or inaccurate language, please fill out this feedback form to report it and suggest alternative language.