Join Joey D'Antoni for an in-depth discussion in this video Why stored procedures are better than views for reports, part of SQL Server Performance for Developers.
- [Narrator] You've learned about views and nested views,…and their problems and how they can be…very difficult to troubleshoot,…particularly when performance goes awry.…In this module, we're going to talk about…why stored procedures are better than views.…I'm going to speak, in the beginning of this,…to a specific use case where I commonly see…these two patterns or bad decisions made,…and that's business intelligence or reporting projects.…And these mistakes tend to happen not from developers,…but from business analysts who are writing to sequel,…and can maybe get a little bit scared…of the complexity of a stored procedure…even though it's effectively the same code base as a view.…
They'll go ahead and create views for reports,…and then we end up with that same nested view problem.…What I'd like you to take away from this is…if you're involved with any of those projects,…or you're near one,…you want to be the person who recommends that…you implement stored procedures as a standard,…just because it's a much better way…
- 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.