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.

Download ppt

Download the sample script:

 

Code Camp 9

April 5th
2008

 Southern New England SQL Server User Group

July 9th 2008

 SQL Pass 2008
Community Summit

Nov 19-21
Seattle, WA

                   


RSS as HTML

Personal Blog
 
New Tips:

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

Big Data:
Working with Terabytes
in SQL Server
July 9 '08

Nov 19-21
SQL Pass 2008

Full Schedule