|
Big Data: Managing Terabytes with SQL Server
Level:
Intermediate
Track:
n/a
Starts:
Apr 5 2008 4:50 PM
Ends:
Apr 5 2008 6:05 PM
Room:
MPR A
Speaker:
Andrew Novick
The modern data warehouse can grow to billions of rows and several terabytes. This presentation takes a look at the techniques used to manage all that data. The topics:
- Storage Architecture - Direct Attach/Sans/Nas
- Organizing data through files and filegroups.
- The ETL (Enter-Test-Load) process
- Partitioned Tables and Partitioned Views for query optimization
- Sliding window techniques to combine the above.
|