N S

Novick Software Management • Design • Programming • Training • Consulting

   

 

 

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:

Loading SQL Profiler trace (.trc) files with fn_trace_gettrace
Upcoming
Presentations:

Defending
SQL Server
from SQL
Injection Attacks
July 8, 2009
RI SQL Server

Full Schedule