Join Joey D'Antoni for an in-depth discussion in this video The perils of storing files in your database, part of SQL Server Performance for Developers.
- [Instructor] Let's talk about storing files…in the database.…This is a fairly common application design pattern.…One of the more famous implementations of this design…is in the SharePoint database,…which uses it to store content.…There are cost and benefits, just like anything,…of storing files in the database.…Let's talk about what some of those are.…Let's remember how SQL Servers stores data.…SQL server stores data in 8K pages.…Like the pictures of the files…we have in the doctors office there,…each of those folders is made up of many pages.…
Files can frequently be much larger than 8K.…I've seen Word docs and PowerPoint presentations…that are megs upon megs.…And when you start talking about the number of pages…that are going to get allocated by SQL Server,…that's going to be a whole lot.…And it's not that it's problematic…to store that much data in SQL Server.…We have databases in SQL Server that run…into hundreds of terabytes.…The problem is that in order to retrieve your file,…SQL Server is going to have to read that sheer number…
- 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.