Join Joey D'Antoni for an in-depth discussion in this video Where you might not want a clustered index, part of SQL Server Performance for Developers.
- [Narrator] You've learned about why, most of the time,…you should probably always use a clustered index…on your SQL Server tables.…Now, let's talk about the few scenarios…where you might not want a clustered index.…These do exist and different people use…SQL Server in many different ways, so it is important,…as you gain mastery of the development process,…to have an understanding of what scenarios are good…for what design patterns.…We talk about design patterns for where…we don't necessarily want a clustered index,…we're going to be mainly looking at things…like E.T.L. staging tables.…
If we think about a data warehouse,…where we're unloading a lot of data each day,…or maybe even a few times a day, from disparate,…we'll say for example, point of sale systems,…say we want to have a record of all of our sales…at all of our store locations.…You know, we're loading that into a data warehouse…a few times a day, and that could be…hundreds of thousands of records at a time,…depending on the nature of your business.…
- Query execution
- How to read an execution plan
- What not to do with SQL Server
- Why cursors are bad
- Why scalar UDFs are expensive
- Datatypes and design
- What is a columnstore index?
- Transaction isolation
Skill Level Intermediate
1. Query Execution
2. What Not to Do with SQL Server
3. Datatypes and Design
4. Temporary Objects
7. Isolation Levels
Next steps2m 15s
- 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.