Join Joey D'Antoni for an in-depth discussion in this video What to do instead of cursors, part of SQL Server Performance for Developers.
- [Instructor] We've talked about how cursors…and while loops are bad operations…and why you shouldn't do them,…but we didn't exactly show a lot of detail…on how to do this better in a set-based fashion.…We've talked about it,…but here let's take a look at some examples…of what you can do instead of cursors.…So there are a lot of join types…and join operations in SQL Server…whether we're talking about inner joins…which will bring back records that equal each other…or left adder joins which will bring back all records…that maybe don't even include a match.…It also helps to understand…how temporary objects in SQL Server work…and where you should use temp tables and global temp tables…and table-valued functions and parameters.…
Later in the course, there will be a module…where we'll talk specifically about those objects…and how you can use them…and choose which one most effectively,…but those are really your weapons of choice…to do in lieu of cursors.…You have the full range of join operations in SQL Server.…You can create temporary objects…
- 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.