Join Martin Guidry for an in-depth discussion in this video Using indexes, part of Designing Database Solutions for SQL Server 2012.
- View Offline
- Exercise Files
- In this section, I'd like to talk about using Indexes…in SQL Server 2012 to help improve the performance…of certain types of queries.…I have a query staged that we're going to work with…in your Exercise Files.…I'll take all of this and copy it into a new query window.…Let's talk a little bit about what this query does.…First line, Line 1, will drop the clean buffers…And what that does is it clears out the cache.…
All of the data that may have been cached in memory…will be cleared out.…We commonly do this when we're running…some performance tests,…'cause we want to make sure every query…runs in the same environment,…so we clear out the cache before each query.…The query starts on Line 5, we'll see that…we're going to select the top 200 CarrierTrackingNumbers.…We're selecting from the SalesOrderDetail table.…Line 7 shows us that we're looking…where CarrierTrackingNumber IS NOT NULL,…Line 8 shows us that we are going to ORDER the results…BY CarrierTrackingNumber,…so I'll go ahead and execute this query.…
All right, we see that our query completed.…
- 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.