Join Simon Allardice for an in-depth discussion in this video Understanding and creating indexes, part of SQL Server 2008 Essential Training.
Flip to the back of any thick technical book and you're going to find an index.…If you need to look up some content that's buried somewhere in a thousand pages…of text, you're going to turn to the back of the book, scan through the index to…find what you're looking for, say deviation analysis, realize it's on page 322 and…then turn directly to that section to read that content.…Indexes give you a quick way to look something up.…That's what they do in books and that's what they do in databases.…When we're working with SQL Server 2008, we can create two kinds of index.…
The first is what's called a clustered index.…A clustered index is applied to one of the columns in our table and it will…order our table based on that index.…In this case I'm looking at it as the CustomerID in ascending order.…If for example I remove the clustered index from that column and applied it to…the LastName column, it would require that the data itself be reorganized…internally based on that clustered index.…So this method of indexing will actually have an effect on the internal…
- Using T-SQL (Transact-SQL)
- Managing databases with SQL Server Management Studio
- Understanding database normalization
- Using SELECT statements
- Building indexes
- Monitoring database size and integrity
- Backing up and restoring databases
- Creating functions and stored procedures
- Managing database permissions
- Creating and formatting reports
- Adding charts to reports
- Creating and executing a simple SSIS package
Skill Level Beginner
1. Getting Started
2. Installing SQL Server 2008 R2
3. Tools and System Databases
SQL Server system databases2m 22s
4. Creating Databases
5. Importing Existing Data
6. Retrieving Data with SQL
7. Inserting and Updating Data
8. SQL Functions
9. Stored Procedures and Transactions
10. Core Administration Tasks
11. Backing Up and Restoring
12. Security Features
13. Reporting Services
14. Integration Services
- 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.