Novick Software
SQL Server Consulting • Design • Programming • Tuning

  andy novick is a sql server mvp

 

 

Big Data
Managing Terabytes of Data with SQL Server

Storage management and partitioning techniques

A data warehouse can grow to billions of rows and several terabytes of data.  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.

Here's Andy delivering the presentation at SQL PASS 2008.

Download the presentation:   Updated 11/15/08

Download the sample script: Updated 11/19/08

 

Code Camp 9

April 5th
2008

 Southern New England SQL Server User Group

July 9th 2008

 Conn Code Camp
Aug 16, 2008

 

 Fairfield Westchester

Code Camp

Nov 7

2008

                   

SQL Pass 2008
Community Summit

Nov 19-21
Seattle, WA

 New England SQL Server User Group

Dec 11 2008


RSS as HTML

Personal Blog
 
New Tips:

Use dsinit to set the SQL Server instance for Windows Azure dev storage
Upcoming
Presentations:

SQL PASS
Nov 7, '12
Biggest
Loser: DB
Edition

Full Schedule