SQL Server 2008 Analysis Services Training Video: Chapter Intro a nd the Challenges LOBs Present

Chapter Intro and the Challenges LOBs Present - view details
Here, Trainer Scott Whigham starts with a quick overview of what's covered in this chapter, and explains where you are in the course. You'll learn about two special requirements for CLOBs and BLOBs: storage needs and query techniques. Using some examples, Scott demonstrates each of these requirements in detail and begins a discussion of full-text indexes and full-text search (FTS) that will be continued in the next video.

Highlights from this video:What's included in this chapterWhere you are in the context of the course
Chapter pre-requisites
The special requirements for CLOBs and BLOBs since they're largeStorage needsSpecial query techniquesDemonstrations using example dataAn estimator tool: the SQL Server DataSizerWhat is the purpose of full-text indexes and the full-text search (FTS)?
and much more Source: http://www.learnitfirst.com/Course/161/Video/3096/Chapter-Intro.aspx Course: http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx Skill Level: 100 (Beginner) Length: 11:15 (23.3MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: introduction, blob data, clob data, full-text indexing, full-text search, fts, filestream, lob storage needs, lob query techniques, sql server datasizer tool, proximity search

This video comes from the SQL Server 2008 Analysis Services online training course, Transact-SQL Programming: SQL Server 2008/R2. And be sure to check out even more SQL Server Analysis Services training videos.