Events

SQL 2008 Data Structures

3/12/2014 5:30 pm - 7:30 pm

Price: 0.00

Click here to visit the event Web site for more information

Click here to see the event's Facebook page

E-mail: aaron.k.kelton@gmail.com

Phone: (501) 515-1586

Location: Main Library

Address: 100 Rock Street, Little Rock, AR 72201

Sathya Nekkanti will discuss SQL server 2008 data structures, specifically covering Data Compression, Sparse columns and Filestream. Sathya will discuss how the Data compression works in SQL server 2008 and how to understand the data structure of the compressed data. He will talk about when to use sparse columns, how the data structure looks internally with sparse columns, some of the traditional alternative ways of storing heterogeneous data instead of sparse columns, and their benefits and pitfalls. Finally, he will dive into the FileStream feature in SQL server and its data structure.