From the course: Microsoft SQL Server 2016: Query Data
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Understanding processing stages - SQL Server Tutorial
From the course: Microsoft SQL Server 2016: Query Data
Understanding processing stages
- [Instructor] In this lesson, we'll explain how the SQL Server query engine processes the queries that you write. Understanding these stages in the order in which they're executed will help you write better queries and will also help you understand perhaps why the results don't match what you intended should things go wrong. If we think about how we ask for information in everyday life we can shed some light on how a query may be processed by a database engine. For example, if you were to ask a friend to find information about your favorite sports team, such as their current standings, where would they look for that information if you don't specify a source? They likely are not able to pull the information out of memory, although perhaps some devout fans could. So asking a database for information without specifying where to get the data will result in a failure. We think in terms of what we are looking for but there is also a consideration for where to find it. A lot of database…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.