Join Martin Guidry for an in-depth discussion in this video Working with query plans, part of Designing Database Solutions for SQL Server 2012.
- View Offline
- Exercise Files
- In this section, I'd like to talk about…one of the tools available to us…to help us plan what indexes we're going to create…and that is the query execution plan.…On the standard tool bar, just to the right of the debug,…there is an option for display estimated execution plan.…I'll go ahead and click on that…and we'll see that it pulls up…underneath my query, some graphical elements.…I'll re-size some windows so we can…see that a little better.…
The top part Query 1 is just the drop clean buffers.…That's not what we're interested in.…We're much more interested in the bottom part of this…which is the execution plan for the select top 200…carrier tracker numbers.…Execution plans are read from right to left…instead of like most things in the English language,…we read from left to right,…but query execution plans go the opposite way.…They go from right to left.…So we'll see the first step is this one…all the way on the right, the index seek…and if we hover our mouse over that,…we can see plenty of detail about…what's going to happen in that index seek.…
- Planning the database infrastructure
- Designing databases vs. data warehouses
- Designing the physical database implementation
- Planning for partitioning
- Adding FileStream data
- Monitoring server health
- Managing SQL Server with PowerShell
Skill Level Intermediate
1. Designing a Database Server Infrastructure
2. Designing a Logical Database Schema
3. Designing a Physical Database Implementation
4. Incorporating Data Files into Databases
5. Tuning Database Performance
6. Policy-Based Management
7. Monitoring Server Health
Exploring health data5m 3s
8. Managing SQL Server with PowerShell
- 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.