- [Instructor] SQL server uses memory for a lot of things,…it uses memory to cash data from disk.…A lot of people associate the memory allocated to a query…as to how much data it's retrieving from cash,…and while it does retrieve data from cash…when we talk about memory and we talk about execution plans…typically what we're talking about is the memory…that's needed to store in-transit rows…for join and sort operations.…So when a query execution plan is compiled…for a given SQL statement,…the database engine estimates the minimum amount…of memory required for execution,…and then the ideal memory size that it would have…to have all of those rows fit in memory.…
And so that memory grant is based on the estimated number…of rows for the operator and the associated row size.…So if your cardinality estimates are inaccurate,…you have bad statistics, skewed data,…your performance can suffer with this.…So one of the things Microsoft introduced in SQL server 2017…is this memory grant feedback notion,…and sometimes you can address…
- Querying with SQL Graph
- String functions in SQL 2017
- Adaptive query processing
- Docker containers and SQL
- Deploying CLR code with SQL Server on Linux
- Working with SQL Operations Studio
- Using snippets
- Code deployment using GIT
Skill Level Intermediate
1. New Features Overview
2. Adaptive Query Processing
3. SQL Server on Linux
4. SQL Server Operations Studio
Using snippets3m 57s
Next steps1m 39s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.