Join Martin Guidry for an in-depth discussion in this video Understanding indexes, part of Designing Database Solutions for SQL Server 2012.
- SQL Server 2012 supports many different…types of indexes, and I'd like to talk about…each one of them briefly here.…The different types are clustered, nonclustered,…columnstore, spatial,…XML, and full-text.…A clustered index determines…how a table is written to disk.…So if we say that a certain table has a clustered…index on a field like name, then the records…of that table will be written to the disk…in alphabetical order by name.…
This is gonna provide the biggest performance increase.…If you ever need to search that table by name,…the machine will have an advantage in reading that…because everything is organized by name.…Also, if you run a query that should return…the results sorted by name, again that will…already be done for you so you could see…a significant performance increase.…We are only allowed one clustered index per table.…When you define a primary key on a table,…the database engine will automatically create…a clustered index for that field.…
You can go back and change that, but it's fairly uncommon.…
- 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.