- [Instructor] One of the long-standing issues we've had…with databases, and it's not so much an issue as it is just…a behavior of databases, is called parameter sniffing…and what happens is, SQL Server compiles a stored procedure…or even ad hoc SQL that uses input perimeters.…The first time the procedure is run,…inputs it in the plan cache,…if you're using optimize for ad hoc it may do it twice,…so there is an exception to that.…Every time that procedure is executed again,…SQL Server will use that execution plan that's in the cache,…unless there's a reason for recompilation.…
Like for example, a new index, statistics updates,…a change to the query, a recompile statement,…there are, I think, 11 different behaviors…that will need to re-compiles.…The potential problem with this is,…if the first time you execute that stored procedure,…the parameters generate an acceptable plan…for that parameter, however,…other parameters in the table that are frequently called,…may not work well with that plan.…For example, if you had a table that had a million rows…
- 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.